/*
 Navicat MySQL Data Transfer

 Source Server         : local
 Source Server Version : 80015
 Source Host           : localhost
 Source Database       : test

 Target Server Version : 80015
 File Encoding         : utf-8

 Date: 07/25/2019 16:30:43 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `es_comment_gallery`
-- ----------------------------
DROP TABLE IF EXISTS `es_comment_gallery`;
CREATE TABLE `es_comment_gallery` (
  `img_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `comment_id` int(10) DEFAULT NULL COMMENT '主键',
  `original` varchar(255) DEFAULT NULL COMMENT '图片路径',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `img_belong` int(10) DEFAULT '0' COMMENT '图片所属 0：初评，1：追评',
  PRIMARY KEY (`img_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='评论图片(es_comment_gallery)';

-- ----------------------------
--  Records of `es_comment_gallery`
-- ----------------------------
BEGIN;
INSERT INTO `es_comment_gallery` VALUES ('1', '38', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/0A8D44CE6BFA4344996BA86B0E6D5ACB.JPG', '0', '0'), ('2', '38', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/35BBC8E6B85D4B4A9981EB17BEE46168.png', '1', '0'), ('3', '38', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/909301FCD00D4BAD9414A351D80646AB.png', '2', '0'), ('4', '38', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/9CA7DDB594AB46CF8B5907B80CB5399B.JPG', '3', '0'), ('5', '38', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/155C59F9AAA6426D9BC2D40D688D598F.JPG', '4', '0'), ('6', '39', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/F1C4CF43E3B349BE8AC4C3E82D9382F0.png', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `es_comment_reply`
-- ----------------------------
DROP TABLE IF EXISTS `es_comment_reply`;
CREATE TABLE `es_comment_reply` (
  `reply_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `comment_id` int(10) DEFAULT NULL COMMENT '评论id',
  `parent_id` int(10) DEFAULT NULL COMMENT '回复父id',
  `content` longtext COMMENT '回复内容',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建时间',
  `role` varchar(50) DEFAULT NULL COMMENT '商家或者买家',
  `path` varchar(100) DEFAULT NULL COMMENT '父子路径0|10|',
  PRIMARY KEY (`reply_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评论回复(es_comment_reply)';

-- ----------------------------
--  Table structure for `es_connect`
-- ----------------------------
DROP TABLE IF EXISTS `es_connect`;
CREATE TABLE `es_connect` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `member_id` int(50) DEFAULT NULL COMMENT '会员id',
  `union_id` varchar(50) DEFAULT NULL COMMENT '第三方唯一标示',
  `union_type` varchar(50) DEFAULT NULL COMMENT '信任登录类型',
  `unbound_time` bigint(50) DEFAULT NULL COMMENT '解绑时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='信任登录(es_connect)';

-- ----------------------------
--  Table structure for `es_connect_setting`
-- ----------------------------
DROP TABLE IF EXISTS `es_connect_setting`;
CREATE TABLE `es_connect_setting` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` varchar(50) DEFAULT NULL COMMENT '授权类型',
  `config` longtext COMMENT '参数组',
  `name` varchar(50) DEFAULT NULL COMMENT '标题',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='信任登录参数(es_connect_setting)';

-- ----------------------------
--  Records of `es_connect_setting`
-- ----------------------------
BEGIN;
INSERT INTO `es_connect_setting` VALUES ('15', 'QQ', '[{\"name\":\"网页端参数 （PC，WAP，微信网页端）\",\"configList\":[{\"key\":\"qq_pc_app_id\",\"name\":\"AppId\",\"value\":\"输入qq网页信任登录 AppID\"},{\"key\":\"qq_pc_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq网页信任登录 AppKey\"}]},{\"name\":\"原生-APP参数(安卓)\",\"configList\":[{\"key\":\"qq_native_android_app_id\",\"name\":\"AppId\",\"value\":\"输入qq 原生-APP参数(安卓) AppID\"},{\"key\":\"qq_native_android_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq 原生-APP参数(安卓) AppKey\"}]},{\"name\":\"原生-APP参数(IOS)\",\"configList\":[{\"key\":\"qq_native_ios_app_id\",\"name\":\"AppId\",\"value\":\"输入qq 原生-APP参数(IOS) AppId\"},{\"key\":\"qq_native_ios_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq 原生-APP参数(IOS) AppKey\"}]},{\"name\":\"RN-APP参数(安卓)\",\"configList\":[{\"key\":\"qq_rn_android_app_id\",\"name\":\"AppId\",\"value\":\"输入qq RN-APP参数(安卓) AppId\"},{\"key\":\"qq_rn_android_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq RN-APP参数(安卓) AppKey\"}]},{\"name\":\"RN-APP参数(IOS)\",\"configList\":[{\"key\":\"qq_rn_ios_app_id\",\"name\":\"AppId\",\"value\":\"输入qq RN-APP参数(IOS) AppId\"},{\"key\":\"qq_rn_ios_app_key\",\"name\":\"AppKey\",\"value\":\"输入qq RN-APP参数(IOS) AppKey\"}]}]', 'QQ信任登录参数配置'), ('16', 'WEIBO', '[{\"name\":\"网页端参数 （PC，WAP，微信网页端）\",\"configList\":[{\"key\":\"weibo_pc_app_key\",\"name\":\"app_key\",\"value\":\"输入 微博信任登录app_key\"},{\"key\":\"weibo_pc_app_secret\",\"name\":\"app_secret\",\"value\":\"输入 微博信任登录app_secret\"}]},{\"name\":\"原生-APP参数\",\"configList\":[{\"key\":\"weibo_app_app_key\",\"name\":\"app_key\",\"value\":\"输入 微博信任登录app_key\"},{\"key\":\"weibo_app_app_secret\",\"name\":\"app_secret\",\"value\":\"输入 微博信任登录app_secret\"}]},{\"name\":\"RN-APP参数\",\"configList\":[{\"key\":\"weibo_rn_app_key\",\"name\":\"app_key\",\"value\":\"输入 微博信任登录app_key\"},{\"key\":\"weibo_rn_app_secret\",\"name\":\"app_secret\",\"value\":\"输入 微博信任登录app_secret\"}]}]', '微博信任登录参数配置'), ('17', 'WECHAT', '[{\"name\":\"PC网页端参数\",\"configList\":[{\"key\":\"wechat_pc_app_id\",\"name\":\"app_id\",\"value\":\"请输入微信PC登录app_id\"},{\"key\":\"wechat_pc_app_key\",\"name\":\"app_key\",\"value\":\"请输入微信PC登录app_key\"}]},{\"name\":\"微信网页端参数\",\"configList\":[{\"key\":\"wechat_wechat_app_id\",\"name\":\"app_id\",\"value\":\"请输入微信网页端登录app_id\"},{\"key\":\"wechat_wechat_app_key\",\"name\":\"app_key\",\"value\":\"请输入微信网页端登录app_key\"}]},{\"name\":\"原生-APP参数\",\"configList\":[{\"key\":\"wechat_app_app_id\",\"name\":\"app_id\",\"value\":\"请输入微信原生-APP登录app_id\"},{\"key\":\"wechat_app_app_key\",\"name\":\"app_key\",\"value\":\"请输入微信原生-APP登录app_key\"}]},{\"name\":\"RN-APP参数\",\"configList\":[{\"key\":\"wechat_rn_app_id\",\"name\":\"app_id\",\"value\":\"请输入微信RN-APP登录app_id\"},{\"key\":\"wechat_rn_app_key\",\"name\":\"app_key\",\"value\":\"请输入微信RN-APP登录app_key\"}]},{\"name\":\"小程序参数\",\"configList\":[{\"key\":\"wechat_miniprogram_app_id\",\"name\":\"app_id\",\"value\":\"请输入小程序登录app_id\"},{\"key\":\"wechat_miniprogram_app_key\",\"name\":\"app_key\",\"value\":\"请输入小程序登录app_key\"}]}]', '微信参数配置'), ('18', 'ALIPAY', '[{\"name\":\"网页端参数 （PC，WAP）参数\",\"configList\":[{\"key\":\"alipay_pc_app_id\",\"name\":\"app_id\",\"value\":\"输入支付宝 app_id\"},{\"key\":\"alipay_pc_private_key\",\"name\":\"商户私钥\",\"value\":\"输入商户 私钥\"},{\"key\":\"alipay_pc_public_key\",\"name\":\"支付宝公钥\",\"value\":\"输入支付宝 公钥\"}]},{\"name\":\"app端参数\",\"configList\":[{\"key\":\"alipay_app_app_id\",\"name\":\"app_id\",\"value\":\"输入支付宝 app_id\"},{\"key\":\"alipay_app_private_key\",\"name\":\"商户私钥\",\"value\":\"输入商户 私钥\"},{\"key\":\"alipay_app_public_key\",\"name\":\"支付宝公钥\",\"value\":\"输入支付宝 公钥\"}]}]', '支付宝参数配置');
COMMIT;

-- ----------------------------
--  Table structure for `es_member`
-- ----------------------------
DROP TABLE IF EXISTS `es_member`;
CREATE TABLE `es_member` (
  `member_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '会员ID',
  `uname` varchar(255) DEFAULT NULL COMMENT '会员登陆用户名',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `password` varchar(255) DEFAULT NULL COMMENT '会员登陆密码',
  `create_time` bigint(20) DEFAULT NULL COMMENT '会员注册时间',
  `sex` int(1) DEFAULT NULL COMMENT '会员性别',
  `birthday` bigint(20) DEFAULT NULL COMMENT '会员生日',
  `province_id` int(10) DEFAULT NULL COMMENT '所属省份ID',
  `city_id` int(10) DEFAULT NULL COMMENT '所属城市ID',
  `county_id` int(10) DEFAULT NULL COMMENT '所属县(区)ID',
  `town_id` int(10) DEFAULT NULL COMMENT '所属城镇ID',
  `province` varchar(255) DEFAULT NULL COMMENT '所属省份名称',
  `city` varchar(255) DEFAULT NULL COMMENT '所属城市名称',
  `county` varchar(255) DEFAULT NULL COMMENT '所属县(区)名称',
  `town` varchar(255) DEFAULT NULL COMMENT '所属城镇名称',
  `address` varchar(255) DEFAULT NULL COMMENT '详细地址',
  `mobile` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `tel` varchar(255) DEFAULT NULL COMMENT '座机号码',
  `grade_point` bigint(20) DEFAULT NULL COMMENT '等级积分',
  `msn` varchar(255) DEFAULT NULL COMMENT '会员MSN',
  `remark` varchar(255) DEFAULT NULL COMMENT '会员备注',
  `last_login` bigint(20) DEFAULT NULL COMMENT '上次登陆时间',
  `login_count` int(10) DEFAULT NULL COMMENT '登陆次数',
  `is_cheked` int(1) DEFAULT NULL COMMENT '邮件是否已验证',
  `register_ip` varchar(255) DEFAULT NULL COMMENT '注册IP地址',
  `recommend_point_state` int(10) DEFAULT NULL COMMENT '是否已经完成了推荐积分',
  `info_full` int(1) DEFAULT NULL COMMENT '会员信息是否完善',
  `find_code` varchar(255) DEFAULT NULL COMMENT 'find_code',
  `face` varchar(255) DEFAULT NULL COMMENT '会员头像',
  `midentity` int(10) DEFAULT NULL COMMENT '身份证号',
  `disabled` int(8) DEFAULT NULL COMMENT '会员状态',
  `consum_point` bigint(20) DEFAULT NULL COMMENT '消费积分',
  `nickname` varchar(255) DEFAULT NULL COMMENT '昵称',
  PRIMARY KEY (`member_id`) USING BTREE,
  INDEX `ind_member_uname`(`uname`) USING BTREE,
  INDEX `ind_member_mobile`(`mobile`) USING BTREE,
  INDEX `ind_member_email`(`email`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COMMENT='会员表(es_member)';

-- ----------------------------
--  Records of `es_member`
-- ----------------------------
BEGIN;
INSERT INTO `es_member` VALUES ('2', 'shoptnt', '2459931371@qq.com', '94757b9164d28f1611abb019e476726b', '1421329021', '1', '0', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', '', '', '84', null, null, '1536046991', '1', '0', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/null/55D38B934E6F4E13AE0C906807173295.JPG', '0', '0', '84', 'shoptnt'), ('6', 'demo_woman', 'demo_woman@qq.com', '5d6bfc690b4e5aa1f6a6eeb3ba06005f', '1427854864', '1', '0', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', '', '', '157', null, null, '1544063195', '1', '0', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/null/206F856561ED4A9EB5CEBD0A4E2E8E29.GIF', '0', '0', '157', 'demo_woman'), ('11', 'toys', 'toys@qq.com', 'dd36834705f598cc078f6865def7f0cf', '1427962143', '1', '0', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', '', '', '102', null, null, '1544063237', '1', '0', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/null/5A0A170E22814619B5364CB38305F52E.GIF', '0', '0', '102', 'toys'), ('16', 'food', 'food@qq.com', 'db383ded6a3f1efe1b9e9be146bdeae0', '1428651298', '1', '-28800', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', '13233333332', '', '25327', null, '', '1544063310', '1', '0', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/null/B79BBB3E76BD49508998F30A211E01EC.png', '0', '0', '25327', 'asasdsadasd'), ('25', 'superman', 'superman@qq.com', '34f0e4bd96fbdbdd73a0fc1a53029988', '1464430868', '1', '0', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', null, '', '70', null, null, '1544063337', '1', '0', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/null/F048B8CD2A68472CAC5EACE151B2EDCC.GIF', '0', '0', '70', 'superman'), ('26', 'kans', 'kansa@qq.com', 'cc5f295e4c8b28b5ff6d0a378005fe2f', '1464509078', '0', '0', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', null, '', '79', null, null, '1544063372', '1', '0', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/8F14D2C439004507AA3B8B4D00AD2A6C.png', '0', '0', '79', 'kans'), ('27', 'appliance', '', '683b618f110bd6450499f7ae6f80a252', '1508506621', '1', '1506787200', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '地址', '13300011111', '', '135328', null, null, '1544063398', '1', '0', '0:0:0:0:0:0:0:1', '0', '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '0', '0', '135328', 'appliance'), ('28', 'kanon', '11@qq.com', '24ed91416e9450ed3fb14b10d6a71ef3', '1509000654', '1', '1508342400', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '你猜', '13333333333', '', '128142', null, null, '1544063468', '1', '0', '192.168.2.139', '0', '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/AA8B286B84F24B458EA3F67C71D8E2BD.jpg', '0', '0', '128142', 'kanon'), ('29', 'wanghui', '22@qq.com', '3172d35318e8ffcb95b50d7fb89d9721', '1509000745', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, null, null, '419', null, null, '1509011450', '0', '0', '192.168.2.139', '0', '0', null, '', '0', '0', '419', 'wanghui'), ('30', 'xulipeng', '33@qq.com', 'c8ed9d8201d3f9cdbf2b3c79018c4019', '1509000772', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, null, null, '50', null, null, '1509000772', '0', '0', '192.168.2.139', '0', '0', null, '', '0', '0', '50', 'xulipeng'), ('31', 'spring', '99@qq.com', 'a6852255248e7f2e5e493d001c0e4806', '1509009430', '0', '1508342400', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '哼', '13333333333', '', '63965', null, null, '1509356340', '0', '0', '192.168.2.139', '0', '0', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/A3EFA87D429F4BC48E7F010D59C546AE.jpg', '0', '0', '63965', 'spring'), ('32', 'martin', '00@qq.ccom', '093614ebaa32605e9414c88db13f0bfa', '1509009465', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, null, null, '0', null, null, '1509009465', '0', '0', '192.168.2.139', '0', '0', null, '', '0', '0', '0', 'martin'), ('33', 'java', '123456@qq.com', '3085eb2c776bfde4806971be381e265f', '1509009516', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, null, null, '50', null, null, '1509009517', '0', '0', '192.168.2.139', '0', '0', null, '', '0', '0', '50', 'java'), ('34', '六月的雨', '9090@qq.com', 'ea194b87d9fef34b40a635d33b3e58e8', '1509009562', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, null, null, '5', null, null, '1509088232', '0', '0', '192.168.2.139', '0', '0', null, '', '0', '0', '5', '六月的雨'), ('35', '陈冠希_', '9898@qq.com', '319ba810ca4304285a464b4301ff96cd', '1509009674', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, null, null, '3162', null, null, '1509085511', '0', '0', '192.168.2.139', '0', '0', null, '', '0', '0', '3162', '陈冠希_'), ('36', '秋刀鱼的滋味', '8888@qq.com', 'dad54e45a6db3d8015361d58aa78c37a', '1509009737', '0', '1508256000', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '0.0', '13333333333', '', '49693', null, null, '1509356392', '0', '0', '192.168.2.139', '0', '0', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/619A016E4C29439290CC95AE3ED07102.jpg', '0', '0', '49693', '秋刀鱼的滋味'), ('37', '春风十里_不如你', '8272@qq.com', '6db347f89f541258a745897f7c747a70', '1509009786', '0', '1508256000', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '地址', '13333333333', '', '78351', null, null, '1509352996', '0', '0', '192.168.2.139', '0', '0', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/CBFBB8EBCC324ED3A69BF0F2B0D7B50E.jpeg', '0', '0', '78351', '春风十里_不如你'), ('38', '下个路口见', '77@qq.com', 'a6f3301422704a3f7650eb4e2aae363c', '1509009923', '0', '1507046400', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '村里', '13333333333', '', '78954', null, null, '1509009923', '0', '0', '192.168.2.139', '0', '0', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/AD3F672CDF5C4010A5008CFDBAA07A88.jpg', '0', '0', '78954', '下个路口见'), ('39', 'batman', null, '8fdc6afab454dadaf1893b4864592473', '1509073225', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '13355522222', null, '20066', null, null, '1509091992', '0', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '20066', 'batman'), ('40', 'spiderman', null, '97175d61bc468feda5d625ce32972b84', '1509073858', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '13388894444', null, '2548', null, null, '1509093008', '0', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '2548', 'spiderman'), ('41', 'antman', null, 'df35354570a98bb805d8bfefa3fe0b7c', '1509074080', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '18899988888', null, '3209', null, null, '1509094606', '0', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '3209', 'antman'), ('42', 'ironman', null, '1e097151cb09cc5d67f205445271e192', '1509074212', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '17788855544', null, '41664', null, null, '1509094035', '0', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '41664', 'ironman'), ('43', 'hock', null, '42ace5e316d1b3268c5a6b9e79383dd8', '1509074489', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '17788844455', null, '1488', null, null, '1509089167', '0', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '1488', 'hock'), ('44', 'eagle', null, 'b83081bb5ac21aa73c52d647181ea7e2', '1509075137', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '17445554445', null, '10937', null, null, '1509089276', '0', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '10937', 'eagle'), ('45', 'green', null, '242c9ca785be114e7cbc8ae8cfc9d505', '1509075866', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '18999888888', null, '1011', null, null, '1545734441', '4', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '1011', 'green'), ('46', 'blue', null, '0e8c609c1b59a6161fe0495388fa4414', '1509084831', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '17788899999', null, '34727', null, null, '1535447809', '3', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '34727', 'blue'), ('47', 'black', null, '80764252de556de1b0533a4496139b38', '1509084961', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '18855566666', null, '3260', null, null, '1535438520', '1', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '3260', 'black'), ('48', 'lion', null, '2026bd7d5ab6dfd6446529793f5b24d7', '1509085091', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '15566622233', null, '3789', null, null, '1509089619', '0', '0', '192.168.2.230', '0', '0', null, '', '0', '0', '3789', 'lion'), ('49', '麦芽糖_', 'lfl@shoptnt.cn', 'd7db785b1da8bed71f47f4f29d282087', '1509431392', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, null, null, '15775', null, null, '1509431392', '0', '0', '192.168.2.139', '0', '0', null, '', '0', '0', '15775', '麦芽糖_'), ('50', '回到过去', 'xlp@shoptnt.cn', '7d34770825938b7a84418ca01f1286ec', '1509433744', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, null, null, '81355', null, null, '1534847138', '1', '0', '192.168.2.139', '0', '0', null, '', '0', '0', '79855', '回到过去'), ('51', 'm_18555555555', '', '1a19ddb1c95057279cdf1842b9cc08d3', '1534837036', '1', '1534780800', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', '18555555555', '', '2196', null, '', '1535075722', '22', null, '192.168.2.105', null, '1', null, 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/BF491C3A06B746718BBDC4E79633A529.png', null, '0', '2196', 'Andste'), ('52', 'fengkun', '', '0e9b5f071f62520685bed9d640d658b6', '1534917930', '1', '0', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', '15321975080', '', '2', null, '', '1535100978', '3', null, '192.168.2.5', null, '0', null, '', null, '0', '2', 'fengkun'), ('53', 'chopper', null, '762f74f150721bb0ab20ec89bd1ed477', '1535340715', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '13232323232', null, '3', null, null, '1535340715', '1', null, '192.168.2.5', null, '0', null, '', null, '0', '3', 'chopper'), ('54', 'AAA', null, '228f5802bc107ec13f797fbaf536bb55', '1535442162', '1', null, '1', '2816', '6667', '0', '北京', '密云区', '城区', '', null, '18854545544', null, '1', null, null, '1535442163', '1', null, '192.168.2.105', null, '0', null, '', null, '0', '1', 'AAA'), ('55', 'shoptnt7', '', '111777d501c44e2a12e6eae0bdfab636', '1535443163', '1', '0', '1', '2816', '6667', '0', '北京', '密云区', '城区', '', '', '18234124540', '', '2', null, '', '1535507093', '6', null, '192.168.2.5', null, '0', null, '', null, '0', '2', 'shoptnt7');
COMMIT;

-- ----------------------------
--  Table structure for `es_member_address`
-- ----------------------------
DROP TABLE IF EXISTS `es_member_address`;
CREATE TABLE `es_member_address` (
  `addr_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `member_id` int(10) DEFAULT NULL COMMENT '会员ID',
  `name` varchar(255) DEFAULT NULL COMMENT '收货人姓名',
  `country` varchar(255) DEFAULT NULL COMMENT '收货人国籍',
  `province_id` int(10) DEFAULT NULL COMMENT '所属省份ID',
  `city_id` int(10) DEFAULT NULL COMMENT '所属城市ID',
  `county_id` int(10) DEFAULT NULL COMMENT '所属县(区)ID',
  `town_id` int(10) DEFAULT NULL COMMENT '所属城镇ID',
  `county` varchar(255) DEFAULT NULL COMMENT '所属县(区)名称',
  `city` varchar(255) DEFAULT NULL COMMENT '所属城市名称',
  `province` varchar(255) DEFAULT NULL COMMENT '所属省份名称',
  `town` varchar(255) DEFAULT NULL COMMENT '所属城镇名称',
  `addr` varchar(255) DEFAULT NULL COMMENT '详细地址',
  `tel` varchar(255) DEFAULT NULL COMMENT '联系电话(一般指座机)',
  `mobile` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `def_addr` int(1) DEFAULT NULL COMMENT '是否为默认收货地址',
  `ship_address_name` varchar(255) DEFAULT NULL COMMENT '地址别名',
  PRIMARY KEY (`addr_id`),
  KEY `ind_mem_addr` (`member_id`,`def_addr`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='会员收货地址表(es_member_address)';

-- ----------------------------
--  Records of `es_member_address`
-- ----------------------------
BEGIN;
INSERT INTO `es_member_address` VALUES ('1', '27', '王峰', null, '5', '274', '49707', '49973', '三河市', '廊坊市', '河北', '燕郊镇', '维多利亚大厦D座23A07', '', '18618487753', '0', '公司'), ('2', '38', '秋刀鱼', null, '10', '712', '714', '33435', '昂昂溪区', '齐齐哈尔市', '黑龙江', '榆树屯镇', '我是地址', null, '13333333333', '1', ''), ('3', '28', '李奋龙', null, '5', '274', '49707', '49973', '三河市', '廊坊市', '河北', '燕郊镇', '上上城五期楼层自己找', null, '17045678911', '1', '家里'), ('4', '29', '李奋龙', null, '5', '274', '49707', '49973', '三河市', '廊坊市', '河北', '燕郊镇', '上上城五期随便送一家', null, '17067891234', '1', '家里'), ('5', '39', 'asdf', null, '3', '51037', '2987', null, '全境', '河北区', '天津', '', 'adfdsf', null, '13332225555', '1', '家里'), ('6', '40', 'kghkjgk', null, '24', '2150', '2152', '8641', '六枝特区', '六盘水市', '贵州', '岩脚镇', 'tryutyuyu', null, '13336665558', '1', '公司'), ('7', '41', 'vbxbdfg', null, '2', '2813', '51976', null, '城区', '徐汇区', '上海', '', 'sdfdghbvnghj', null, '15554445554', '1', '公司'), ('8', '42', 'ironman', null, '26', '3144', '3960', '12106', '岗巴县', '日喀则地区', '西藏', '昌龙乡', 'dsfasdf', null, '18899988899', '1', '家里'), ('9', '43', 'hock', null, '14', '1201', '1203', '18766', '石台县', '池州市', '安徽', '仁里镇', 'hgjvbnsfdgh', null, '13332225552', '1', '学校'), ('10', '44', 'ytjumyuj', null, '6', '336', '344', '44289', '太谷县', '晋中市', '山西', '北洸乡', 'gm,hjmjh', null, '18999999999', '1', '家里'), ('11', '45', 'green', null, '11', '895', '898', '37877', '突泉县', '兴安盟', '内蒙古', '县城内', 'asdfndsf', null, '18999888888', '1', '家里'), ('12', '46', 'adsfasdf', null, '1', '72', '2799', null, '三环以内', '朝阳区', '北京', '', 'sdfsdfgsdf', null, '17788899999', '1', '家里'), ('13', '47', 'hgjhgj', null, '10', '773', '3364', '51255', '桃山区', '七台河市', '黑龙江', '城区', 'dghsdfgsfd', null, '18855566666', '1', '家里'), ('14', '48', 'asdfsdf', null, '18', '1592', '1598', '13704', '凤凰县', '湘西州', '湖南', '落潮井乡', 'asdfsdgasd', null, '15566622233', '1', '公司'), ('15', '35', '张三', null, '6', '309', '311', '32148', '天镇县', '大同市', '山西', '米薪关镇', '小卖部', null, '13333333333', '1', '家里'), ('16', '34', '张小姐', null, '11', '805', '808', '38347', '土默特右旗', '包头市', '内蒙古', '美岱召镇', '小卖部', null, '13333333333', '1', '家里'), ('17', '31', '二丫', null, '2', '2815', '51975', null, '城区', '长宁区', '上海', '', '203', null, '13333333333', '1', '家里'), ('18', '36', '喵小姐', null, '6', '336', '339', '44295', '昔阳县', '晋中市', '山西', '乐平镇', '0.0', null, '13333333333', '1', ''), ('19', '37', '口水', null, '2', '2813', '51976', null, '城区', '徐汇区', '上海', '', '宿舍楼709', null, '13333333333', '1', '学校'), ('20', '49', '麦芽糖', null, '2', '2813', '51976', null, '城区', '徐汇区', '上海', '', '地址', null, '13333333333', '1', ''), ('21', '50', '张先生', null, '2', '2813', '51976', null, '城区', '徐汇区', '上海', '', '12312313', null, '13333333333', '1', '公司'), ('22', '16', '李先生', null, '6', '303', '304', '36865', '阳曲县', '太原市', '山西省', '中心镇建设管理办公室', '12312313', null, '13333333333', '1', '公司'), ('23', '16', '王先生', null, '5', '142', '143', '5008', '辛集市', '石家庄市', '河北', '辛集镇', '12312313', null, '13333333333', '0', '公司'), ('24', '16', '张先生', null, '26', '2951', '3123', '21181', '林周县', '拉萨市', '西藏', '边交林乡', '12312313', null, '13333333333', '0', '公司'), ('27', '2', '测试', '中国', '2', '2813', '51976', '0', '城区', '徐汇区', '上海', '', '测试地址', null, '13333333333', '1', '家'), ('30', '1', 'AAAAA', '中国', '6', '309', '315', '32163', '浑源县', '大同市', '山西', '蔡村镇', 'asdsadasd', null, '15454353455', '1', ''), ('31', '52', 'fengkun', '中国', '5', '148', '168', '34054', '峰峰矿区', '邯郸市', '河北', '峰峰镇', 'zscfzxc', null, '13636363636', '1', ''), ('32', '52', 'zxczxc', '中国', '5', '142', '154', '42817', '栾城县', '石家庄市', '河北', '楼底镇', 'asdas', null, '13636363636', '0', ''), ('33', '27', '萨达', '中国', '1', '72', '2799', '0', '三环以内', '朝阳区', '北京', '', '萨达撒多撒', null, '13636363636', '1', ''), ('35', '51', 'AAA', '中国', '5', '274', '49707', '49973', '三河市', '廊坊市', '河北', '燕郊镇', '维多路由A座24层23A07', null, '18545454554', '1', '公司'), ('36', '51', 'BBB', '中国', '5', '274', '289', '49735', '大厂县', '廊坊市', '河北', '大厂镇', '大厂人家不喜欢详细地址', null, '18545456564', '0', '家'), ('37', '53', '123', '中国', '1', '72', '2819', '0', '三环到四环之间', '朝阳区', '北京', '', '1312313123133', null, '13213121313', '1', ''), ('38', '55', '123', '中国', '1', '72', '2799', '0', '三环以内', '朝阳区', '北京', '', '123', null, '13212313123', '1', '123');
COMMIT;

-- ----------------------------
--  Table structure for `es_member_ask`
-- ----------------------------
DROP TABLE IF EXISTS `es_member_ask`;
CREATE TABLE `es_member_ask` (
  `ask_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `goods_id` int(10) DEFAULT NULL COMMENT '商品id',
  `member_id` int(10) DEFAULT NULL COMMENT '会员id',
  `content` longtext COMMENT '咨询内容',
  `create_time` bigint(20) DEFAULT NULL COMMENT '咨询时间',
  `reply` longtext COMMENT '回复内容',
  `reply_time` bigint(20) DEFAULT NULL COMMENT '回复时间',
  `reply_status` smallint(1) DEFAULT NULL COMMENT '回复状态 1 已回复 2 未回复',
  `status` smallint(1) DEFAULT NULL COMMENT '状态 ',
  `member_name` varchar(100) DEFAULT NULL COMMENT '卖家名称',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `member_face` varchar(255) DEFAULT NULL COMMENT '会员头像',
  `auth_status` varchar(255) DEFAULT NULL COMMENT '审核状态:PASS_AUDIT(审核通过),REFUSE_AUDIT(审核拒绝)',
  PRIMARY KEY (`ask_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='咨询(es_member_ask)';

-- ----------------------------
--  Table structure for `es_member_collection_goods`
-- ----------------------------
DROP TABLE IF EXISTS `es_member_collection_goods`;
CREATE TABLE `es_member_collection_goods` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `member_id` int(10) DEFAULT NULL COMMENT '会员ID',
  `goods_id` int(10) DEFAULT NULL COMMENT '收藏商品ID',
  `create_time` bigint(20) DEFAULT NULL COMMENT '收藏商品时间',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_price` decimal(20,2) DEFAULT NULL COMMENT '商品价格',
  `goods_sn` varchar(255) DEFAULT NULL COMMENT '商品编号',
  `goods_img` varchar(255) DEFAULT NULL COMMENT '商品图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员商品收藏表(es_member_collection_goods)';

-- ----------------------------
--  Table structure for `es_member_comment`
-- ----------------------------
DROP TABLE IF EXISTS `es_member_comment`;
CREATE TABLE `es_member_comment` (
  `comment_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '评论主键',
  `goods_id` int(10) DEFAULT NULL COMMENT '商品id',
  `sku_id` int(10) DEFAULT NULL COMMENT 'skuid',
  `member_id` int(10) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(255) DEFAULT NULL COMMENT '会员名称',
  `member_face` varchar(255) DEFAULT NULL COMMENT '会员头像',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `content` longtext COMMENT '评论内容',
  `create_time` bigint(20) DEFAULT NULL COMMENT '评论时间',
  `have_image` smallint(1) DEFAULT NULL COMMENT '是否有图片 1 有 0 没有',
  `status` smallint(1) DEFAULT NULL COMMENT '状态  1 正常 0 删除 ',
  `grade` varchar(50) DEFAULT NULL COMMENT '好中差评',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `reply_status` smallint(1) DEFAULT NULL COMMENT '是否回复 1 是 0 否',
  `additional_status` int(10) DEFAULT '0' COMMENT '追加评论状态 0：未追加，1：已追加',
  `additional_content` longtext COMMENT '追加的评论内容',
  `additional_time` bigint(20) DEFAULT NULL COMMENT '追加评论时间',
  `additional_have_image` int(10) DEFAULT NULL COMMENT '追加的评论是否上传了图片 0：未上传，1：已上传',
  PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COMMENT='评论(es_member_comment)';

-- ----------------------------
--  Records of `es_member_comment`
-- ----------------------------
BEGIN;
INSERT INTO `es_member_comment` VALUES ('1', '173', '197', '16', 'food', '', '未来人类(Terrans Force)S4-1060-67S', '好评！', '1534852799', '0', '1', 'good', '20180821000048', '0', '0', null, null, null), ('2', '174', '201', '16', 'food', '', 'Apple iPhone 7 Plus 128GB 亮黑色 ', '好评！', '1534852799', '0', '1', 'good', '20180821000048', '0', '0', null, null, null), ('3', '65', '394', '16', 'food', '', '兰蔻 黑金臻宠精华乳30ml 柔软平滑紧致光泽 淡细纹补水保湿滋润', '好评！', '1534852812', '0', '1', 'good', '20180821000047', '0', '0', null, null, null), ('4', '172', '196', '16', 'food', '', '联想（Lenovo）Y50p-70 15.6英寸游戏笔记本', '好评！', '1534852822', '0', '1', 'good', '20180821000046', '0', '0', null, null, null), ('5', '63', '396', '16', 'food', '', 'LA MER海蓝之谜赋活保湿精华露30ml 水润保湿 润泽', '好评！', '1534852831', '0', '1', 'good', '20180821000045', '0', '0', null, null, null), ('6', '107', '481', '16', 'food', '', '儿童电动车摇摆童车四轮室内车带遥控玩具车可坐人摩托车电动汽车', '好评！', '1534852839', '0', '1', 'good', '20180821000001', '0', '0', null, null, null), ('7', '35', '443', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '唐狮秋冬季情侣装毛衣男女韩版图案小清新圆领套头学生针织衫', '好评！', '1534852917', '0', '1', 'good', '20180821000044', '0', '0', null, null, null), ('8', '121', '467', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '童装男童秋冬装套装2018新款儿童加绒加厚金丝绒卫衣三件套中大童', '好评！', '1534852925', '0', '1', 'good', '20180821000043', '0', '0', null, null, null), ('9', '111', '477', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '亿宝莱高景观婴儿推车可坐可躺轻便携式折叠小孩宝宝双向婴儿童车', '好评！', '1534852933', '0', '1', 'good', '20180821000042', '0', '0', null, null, null), ('10', '110', '478', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '米兔故事机mini儿童早教机宝宝婴儿幼儿玩具学习机', '好评！', '1534852942', '0', '1', 'good', '20180821000040', '0', '0', null, null, null), ('11', '109', '479', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '大型儿童电动车四轮卡丁车小孩玩具汽车宝宝遥控可坐人童车', '好评！', '1534852950', '0', '1', 'good', '20180821000041', '0', '0', null, null, null), ('12', '104', '484', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '双鹰遥控搅拌车工程车电动玩具水泥车混凝土罐车汽车模型儿童男孩', '好评！', '1534852963', '0', '1', 'good', '20180821000039', '0', '0', null, null, null), ('13', '22', '456', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '好评！', '1534852978', '0', '1', 'good', '20180821000038', '0', '0', null, null, null), ('14', '101', '487', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '亲子装2017新款秋冬季母女装针织衫韩版宽松外穿毛衣纯色打底春装', '好评！', '1534852993', '0', '1', 'good', '20180821000037', '0', '0', null, null, null), ('15', '49', '406', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '百雀羚小森羚温和净颜卸妆水脸部眼唇卸妆液清洁毛孔不油腻', '好评！', '1534853006', '0', '1', 'good', '20180821000036', '0', '0', null, null, null), ('16', '48', '407', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '百雀羚三生花舒缓细肤柔润凝乳精华乳液女补水保湿学生', '好评！', '1534853006', '0', '1', 'good', '20180821000036', '0', '0', null, null, null), ('17', '63', '396', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', 'LA MER海蓝之谜赋活保湿精华露30ml 水润保湿 润泽', '好评！', '1534853006', '0', '1', 'good', '20180821000036', '0', '0', null, null, null), ('18', '65', '394', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '兰蔻 黑金臻宠精华乳30ml 柔软平滑紧致光泽 淡细纹补水保湿滋润', '好评！', '1534853006', '0', '1', 'good', '20180821000036', '0', '0', null, null, null), ('19', '302', '391', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', 'honor荣耀畅玩7X尊享版 4GB+128GB 铂光金 移动联通电信4G手机', '好评！', '1534853024', '0', '1', 'good', '20180821000035', '0', '0', null, null, null), ('20', '283', '369', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '未来人类(Terrans Force) X911-1080S-77X 桌面级i7-7700K 双GTX1080显卡 新', '好评！', '1534853024', '0', '1', 'good', '20180821000035', '0', '0', null, null, null), ('21', '234', '289', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '三星 Galaxy S8 Plus S8+（G9550）6G', '好评！', '1534853024', '0', '1', 'good', '20180821000035', '0', '0', null, null, null), ('22', '298', '387', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', 'Apple iPhone 8 Plus 64GB 金色 移动联通电信4G手机', '好评！', '1534853024', '0', '1', 'good', '20180821000035', '0', '0', null, null, null), ('23', '299', '388', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '三星 Galaxy S7 edge（G9350）4+64G版 铂光金 全网通', '好评！', '1534853024', '0', '1', 'good', '20180821000035', '0', '0', null, null, null), ('24', '226', '276', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', 'OPPO R11 Plus 6GB+64GB 玫瑰金', '好评！', '1534853024', '0', '1', 'good', '20180821000035', '0', '0', null, null, null), ('25', '232', '287', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', ' 小米6 全网通 6GB+128GB 探索银限量版', '好评！', '1534853097', '0', '1', 'good', '20180821000031', '0', '0', null, null, null), ('26', '229', '281', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', 'Razer雷蛇 黑寡妇蜘蛛V2幻彩版 lol电竞游戏机械键盘', '好评！', '1534853116', '0', '1', 'good', '20180821000030', '0', '0', null, null, null), ('27', '227', '279', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '樱桃（Cherry）机械键盘G80-3000LSCEU-0白', '好评！', '1534853116', '0', '1', 'good', '20180821000030', '0', '0', null, null, null), ('28', '230', '283', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '小米（MI）小米便携鼠标 智能轻薄便携 无线+蓝牙双连接 家', '好评！', '1534853126', '0', '1', 'good', '20180821000029', '0', '0', null, null, null), ('29', '226', '277', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', 'OPPO R11 Plus 6GB+64GB 玫瑰金', '好评！', '1534853136', '0', '1', 'good', '20180821000028', '0', '0', null, null, null), ('30', '211', '243', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '三洋（SANYO）WF810326BS0S 8公斤', '好评！', '1534853150', '0', '1', 'good', '20180821000027', '0', '0', null, null, null), ('31', '209', '238', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '索尼(SONY)KDL-48W650D 48英寸 全高清LE', '好评！', '1534853162', '0', '1', 'good', '20180821000026', '0', '0', null, null, null), ('32', '208', '237', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '索尼(SONY)KD-55X8500D 55英寸 ', '好评！', '1534853162', '0', '1', 'good', '20180821000026', '0', '0', null, null, null), ('33', '191', '219', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '魅族 魅蓝note5 4G+全网通版 灰色 移动联通电信4G', '好评！', '1534853583', '0', '1', 'good', '20180821000017', '0', '0', null, null, null), ('34', '197', '226', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '美菱(MELING) BCD-551WPCX 551升', '好评！', '1534853592', '0', '1', 'good', '20180821000018', '0', '0', null, null, null), ('35', '193', '221', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '海尔（Haier）BCD-310WDPF 310升多门冰箱 ', '好评！', '1534853606', '0', '1', 'good', '20180821000019', '0', '0', null, null, null), ('36', '195', '225', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '华硕（ASUS）Spatha ROG玩家国度 游戏鼠标', '好评！', '1534853616', '0', '1', 'good', '20180821000020', '0', '0', null, null, null), ('37', '203', '232', '27', 'appliance', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/demo/FFB12FF17B4C4CD18AAD6CC73B69D625.png', '小米（MI）米家IH电饭煲 智能电饭煲 IH电磁环绕加热 手', '好评！', '1534853638', '0', '1', 'good', '20180821000025', '0', '0', null, null, null), ('38', '259', '337', '51', 'm_18555555555', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/BF491C3A06B746718BBDC4E79633A529.png', 'honor荣耀V9 play标配版 3GB+32GB 幻夜黑', '我觉得这部手机啊！太TM好看了\n下面我来插一段代码\n<style>body{dispaly:none}</style>\n<script>console.log(document.cookie)</script>', '1535005135', '1', '1', 'good', '20180823000001', '0', '0', null, null, null), ('39', '259', '337', '51', 'm_18555555555', 'http://shoptnt-statics.oss-cn-beijing.aliyuncs.com/v70/normal/BF491C3A06B746718BBDC4E79633A529.png', 'honor荣耀V9 play标配版 3GB+32GB 幻夜黑', '给你个差评怎么了！这是看得起你！呵呵\n你个野猪佩奇！\n啊', '1535005451', '1', '1', 'bad', '20180823000002', '0', '0', null, null, null), ('40', '22', '456', '2', 'shoptnt', '', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '123123123123', '1535370972', '0', '1', 'good', '20180821000061', '0', '0', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `es_member_coupon`
-- ----------------------------
DROP TABLE IF EXISTS `es_member_coupon`;
CREATE TABLE `es_member_coupon` (
  `mc_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `coupon_id` int(10) DEFAULT NULL COMMENT '优惠券表主键',
  `member_id` int(10) DEFAULT NULL COMMENT '会员主键id',
  `used_time` bigint(11) DEFAULT NULL COMMENT '使用时间',
  `create_time` bigint(11) DEFAULT NULL COMMENT '领取时间',
  `order_id` int(10) DEFAULT NULL COMMENT '订单主键',
  `order_sn` varchar(30) DEFAULT NULL COMMENT '订单编号',
  `member_name` varchar(30) DEFAULT NULL COMMENT '会员昵称',
  `title` varchar(20) DEFAULT NULL COMMENT '优惠券名称',
  `coupon_price` decimal(10,2) DEFAULT NULL COMMENT '优惠券面额',
  `coupon_threshold_price` decimal(10,2) DEFAULT NULL COMMENT '优惠券门槛金额',
  `start_time` bigint(11) DEFAULT NULL COMMENT '使用起始时间',
  `end_time` bigint(11) DEFAULT NULL COMMENT '使用截止时间',
  `used_status` smallint(1) DEFAULT NULL COMMENT '使用状态',
  PRIMARY KEY (`mc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='会员优惠券(es_member_coupon)';

-- ----------------------------
--  Records of `es_member_coupon`
-- ----------------------------
BEGIN;
INSERT INTO `es_member_coupon` VALUES ('1', '1', '51', null, '1534840810', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('2', '2', '51', null, '1534840811', null, null, null, '优惠券2', '20.00', '200.00', '1534840668', '1535040000', '0'), ('3', '2', '51', null, '1534840839', null, null, null, '优惠券2', '20.00', '200.00', '1534840668', '1535040000', '0'), ('4', '1', '51', null, '1534840840', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('5', '2', '51', null, '1534840842', null, null, null, '优惠券2', '20.00', '200.00', '1534840668', '1535040000', '0'), ('6', '1', '51', null, '1534840843', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('7', '1', '51', null, '1534840843', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('8', '2', '51', null, '1534840844', null, null, null, '优惠券2', '20.00', '200.00', '1534840668', '1535040000', '0'), ('9', '1', '51', null, '1534840845', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('10', '2', '51', null, '1534840846', null, null, null, '优惠券2', '20.00', '200.00', '1534840668', '1535040000', '0'), ('11', '1', '51', null, '1534840847', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('12', '2', '51', null, '1534840847', null, null, null, '优惠券2', '20.00', '200.00', '1534840668', '1535040000', '0'), ('13', '1', '51', null, '1534840848', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('14', '2', '51', null, '1534841265', null, null, null, '优惠券2', '20.00', '200.00', '1534840668', '1535040000', '0'), ('15', '1', '51', null, '1534841266', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('16', '1', '51', null, '1534841267', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('17', '1', '51', null, '1534841267', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('18', '3', '50', null, '1534847252', null, null, null, '这是真实的测试', '2.00', '3.00', '1534841653', '1535100853', '1'), ('19', '1', '50', null, '1534847366', null, null, null, '优惠券1', '10.00', '100.00', '1534840668', '1535040000', '0'), ('20', '2', '27', null, '1534848778', null, null, null, '优惠券2', '20.00', '200.00', '1534840668', '1535040000', '1'), ('21', '3', '16', null, '1534849374', null, null, null, '这是真实的测试', '2.00', '3.00', '1534841653', '1535100853', '0'), ('22', '3', '27', null, '1534854420', null, null, null, '这是真实的测试', '2.00', '3.00', '1534841653', '1535100853', '1'), ('23', '4', '51', null, '1534912351', null, null, null, '测试优惠券', '10.00', '100.00', '1533953600', '1535644800', '0'), ('24', '5', '51', null, '1534912354', null, null, null, '测试优惠券2', '15.00', '50.00', '1533953600', '1537891200', '0'), ('25', '5', '51', null, '1534912355', null, null, null, '测试优惠券2', '15.00', '50.00', '1533953600', '1537891200', '0'), ('26', '4', '1', null, '1534912744', null, null, null, '测试优惠券', '10.00', '100.00', '1533953600', '1535644800', '0'), ('27', '5', '1', null, '1534912747', null, null, null, '测试优惠券2', '15.00', '50.00', '1533953600', '1537891200', '0'), ('28', '5', '1', null, '1534912748', null, null, null, '测试优惠券2', '15.00', '50.00', '1533953600', '1537891200', '0');
COMMIT;

-- ----------------------------
--  Table structure for `es_member_notice_log`
-- ----------------------------
DROP TABLE IF EXISTS `es_member_notice_log`;
CREATE TABLE `es_member_notice_log` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '会员历史消息id',
  `member_id` int(8) DEFAULT NULL COMMENT '会员id',
  `content` longtext COMMENT '站内信内容',
  `send_time` bigint(20) DEFAULT NULL COMMENT '发送时间',
  `is_del` int(2) DEFAULT NULL COMMENT '是否删除，0删除，1没有删除',
  `is_read` int(2) DEFAULT NULL COMMENT '是否已读，0未读，1已读',
  `receive_time` bigint(20) DEFAULT NULL COMMENT '接收时间',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=323 DEFAULT CHARSET=utf8 COMMENT='会员站内消息历史(es_member_notice_log)';

-- ----------------------------
--  Records of `es_member_notice_log`
-- ----------------------------
BEGIN;
INSERT INTO `es_member_notice_log` VALUES ('1', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534837036', '1', '0', '1534837036', ''), ('2', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534837049', '1', '0', '1534837049', ''), ('3', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534837112', '1', '0', '1534837112', ''), ('4', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534837477', '1', '0', '1534837477', ''), ('5', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534838831', '1', '0', '1534838831', ''), ('6', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534839794', '1', '0', '1534839794', ''), ('7', '25', '登陆提示：您的会员superman于2018-08-21登陆成功！', '1534840100', '1', '0', '1534840100', ''), ('8', '25', '登陆提示：您的会员superman于2018-08-21登陆成功！', '1534840104', '1', '0', '1534840104', ''), ('9', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534840362', '1', '0', '1534840362', ''), ('10', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534840780', '1', '0', '1534840780', ''), ('11', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534841035', '1', '0', '1534841035', ''), ('12', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534842637', '1', '0', '1534842637', ''), ('13', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534845258', '1', '0', '1534845258', ''), ('14', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534846505', '1', '0', '1534846505', ''), ('15', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534846955', '1', '0', '1534846955', ''), ('16', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534846968', '1', '0', '1534846968', ''), ('17', '50', '登陆提示：您的会员回到过去于2018-08-21登陆成功！', '1534847138', '1', '0', '1534847138', ''), ('18', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534847160', '1', '0', '1534847160', ''), ('19', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534847699', '1', '0', '1534847699', ''), ('20', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534848708', '1', '0', '1534848708', ''), ('21', '2', '登陆提示：您的会员shoptnt于2018-08-21登陆成功！', '1534848992', '1', '0', '1534848992', ''), ('22', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534849018', '1', '0', '1534849018', ''), ('23', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534849342', '1', '0', '1534849342', ''), ('24', '46', '登陆提示：您的会员blue于2018-08-21登陆成功！', '1534849708', '1', '0', '1534849708', ''), ('25', '2', '登陆提示：您的会员shoptnt于2018-08-21登陆成功！', '1534849916', '1', '0', '1534849916', ''), ('26', '2', '登陆提示：您的会员shoptnt于2018-08-21登陆成功！', '1534849941', '1', '0', '1534849941', ''), ('27', '27', '您的订单：订单单号20180821000025已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850117', '1', '0', '1534850117', ''), ('28', '27', '您的订单：订单单号20180821000023已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850193', '1', '0', '1534850193', ''), ('29', '27', '您的订单：订单单号20180821000020已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850204', '1', '0', '1534850204', ''), ('30', '50', '您的订单：订单单号20180821000016已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850212', '1', '0', '1534850212', ''), ('31', '50', '您的订单：订单单号20180821000006已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850220', '1', '0', '1534850220', ''), ('32', '50', '您的订单：订单单号20180821000005已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850229', '1', '0', '1534850229', ''), ('33', '50', '您的订单：订单单号20180821000004已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850236', '1', '0', '1534850236', ''), ('34', '46', '您的订单：订单单号20180821000054已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850249', '1', '0', '1534850249', ''), ('35', '46', '您的订单：订单单号20180821000053已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850256', '1', '0', '1534850256', ''), ('36', '46', '您的订单：订单单号20180821000052已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850263', '1', '0', '1534850263', ''), ('37', '46', '您的订单：订单单号20180821000051已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850271', '1', '0', '1534850271', ''), ('38', '46', '您的订单：订单单号20180821000049已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850280', '1', '0', '1534850280', ''), ('39', '27', '您的订单：订单单号20180821000030已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850292', '1', '0', '1534850292', ''), ('40', '27', '您的订单：订单单号20180821000029已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850300', '1', '0', '1534850300', ''), ('41', '2', '登陆提示：您的会员shoptnt于2018-08-21登陆成功！', '1534850355', '1', '0', '1534850355', ''), ('42', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534850378', '1', '0', '1534850378', ''), ('43', '16', '您的订单：订单单号20180821000048已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850392', '1', '0', '1534850392', ''), ('44', '16', '您的订单：订单单号20180821000046已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850400', '1', '0', '1534850400', ''), ('45', '27', '您的订单：订单单号20180821000035已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850410', '1', '0', '1534850410', ''), ('46', '27', '您的订单：订单单号20180821000033已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850425', '1', '0', '1534850425', ''), ('47', '27', '您的订单：订单单号20180821000031已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850434', '1', '0', '1534850434', ''), ('48', '27', '您的订单：订单单号20180821000028已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850444', '1', '0', '1534850444', ''), ('49', '27', '您的订单：订单单号20180821000026已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850453', '1', '0', '1534850453', ''), ('50', '27', '您的订单：订单单号20180821000024已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850462', '1', '0', '1534850462', ''), ('51', '27', '您的订单：订单单号20180821000019已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850469', '1', '0', '1534850469', ''), ('52', '27', '您的订单：订单单号20180821000027已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850477', '1', '0', '1534850477', ''), ('53', '27', '您的订单：订单单号20180821000018已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850488', '1', '0', '1534850488', ''), ('54', '27', '您的订单：订单单号20180821000017已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850495', '1', '0', '1534850495', ''), ('55', '50', '您的订单：订单单号20180821000013已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850504', '1', '0', '1534850504', ''), ('56', '50', '您的订单：订单单号20180821000012已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850512', '1', '0', '1534850512', ''), ('57', '50', '您的订单：订单单号20180821000010已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850520', '1', '0', '1534850520', ''), ('58', '50', '您的订单：订单单号20180821000011已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850529', '1', '0', '1534850529', ''), ('59', '50', '您的订单：订单单号20180821000009已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850539', '1', '0', '1534850539', ''), ('60', '50', '您的订单：订单单号20180821000008已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850545', '1', '0', '1534850545', ''), ('61', '50', '您的订单：订单单号20180821000007已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850552', '1', '0', '1534850552', ''), ('62', '50', '您的订单：订单单号20180821000003已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850559', '1', '0', '1534850559', ''), ('63', '50', '您的订单：订单单号20180821000002已于2018-08-21发货，运单号：3371504126218。请进入用户中心商品订单查看。', '1534850567', '1', '0', '1534850567', ''), ('64', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534850905', '1', '0', '1534850905', ''), ('65', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534852329', '1', '0', '1534852329', ''), ('66', '16', '您的订单：订单单号20180821000048已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852341', '1', '0', '1534852341', ''), ('67', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534852360', '1', '0', '1534852360', ''), ('68', '11', '登陆提示：您的会员toys于2018-08-21登陆成功！', '1534852395', '1', '0', '1534852395', ''), ('69', '27', '您的订单：订单单号20180821000043已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852431', '1', '0', '1534852431', ''), ('70', '27', '您的订单：订单单号20180821000042已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852440', '1', '0', '1534852440', ''), ('71', '27', '您的订单：订单单号20180821000041已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852446', '1', '0', '1534852446', ''), ('72', '27', '您的订单：订单单号20180821000040已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852453', '1', '0', '1534852453', ''), ('73', '27', '您的订单：订单单号20180821000039已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852460', '1', '0', '1534852460', ''), ('74', '27', '您的订单：订单单号20180821000037已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852467', '1', '0', '1534852467', ''), ('75', '16', '您的订单：订单单号20180821000001已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852479', '1', '0', '1534852479', ''), ('76', '6', '登陆提示：您的会员demo_woman于2018-08-21登陆成功！', '1534852504', '1', '0', '1534852504', ''), ('77', '26', '登陆提示：您的会员kans于2018-08-21登陆成功！', '1534852535', '1', '1', '1534852535', ''), ('78', '16', '您的订单：订单单号20180821000047已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852550', '1', '0', '1534852550', ''), ('79', '16', '您的订单：订单单号20180821000045已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852557', '1', '0', '1534852557', ''), ('80', '27', '您的订单：订单单号20180821000036已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852566', '1', '0', '1534852566', ''), ('81', '27', '您的订单：订单单号20180821000022已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852573', '1', '0', '1534852573', ''), ('82', '27', '您的订单：订单单号20180821000021已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852584', '1', '0', '1534852584', ''), ('83', '50', '您的订单：订单单号20180821000015已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852591', '1', '0', '1534852591', ''), ('84', '25', '登陆提示：您的会员superman于2018-08-21登陆成功！', '1534852620', '1', '0', '1534852620', ''), ('85', '27', '您的订单：订单单号20180821000044已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852657', '1', '0', '1534852657', ''), ('86', '27', '您的订单：订单单号20180821000038已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852666', '1', '0', '1534852666', ''), ('87', '50', '您的订单：订单单号20180821000014已于2018-08-21发货，运单号：1。请进入用户中心商品订单查看。', '1534852672', '1', '0', '1534852672', ''), ('88', '16', '您的订单：订单单号20180821000047已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852804', '1', '0', '1534852804', ''), ('89', '16', '您的订单：订单单号20180821000046已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852817', '1', '0', '1534852817', ''), ('90', '16', '您的订单：订单单号20180821000045已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852826', '1', '0', '1534852826', ''), ('91', '16', '您的订单：订单单号20180821000001已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852835', '1', '0', '1534852835', ''), ('92', '2', '登陆提示：您的会员shoptnt于2018-08-21登陆成功！', '1534852886', '1', '0', '1534852886', ''), ('93', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534852904', '1', '0', '1534852904', ''), ('94', '27', '您的订单：订单单号20180821000044已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852912', '1', '0', '1534852912', ''), ('95', '27', '您的订单：订单单号20180821000043已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852921', '1', '0', '1534852921', ''), ('96', '27', '您的订单：订单单号20180821000042已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852929', '1', '0', '1534852929', ''), ('97', '27', '您的订单：订单单号20180821000040已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852938', '1', '0', '1534852938', ''), ('98', '27', '您的订单：订单单号20180821000041已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852945', '1', '0', '1534852945', ''), ('99', '27', '您的订单：订单单号20180821000039已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852960', '1', '0', '1534852960', ''), ('100', '27', '您的订单：订单单号20180821000038已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852970', '1', '0', '1534852970', ''), ('101', '27', '您的订单：订单单号20180821000037已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852975', '1', '0', '1534852975', ''), ('102', '27', '您的订单：订单单号20180821000036已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852985', '1', '0', '1534852985', ''), ('103', '27', '您的订单：订单单号20180821000035已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534852989', '1', '0', '1534852989', ''), ('104', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534853004', '1', '0', '1534853004', ''), ('105', '27', '您的订单：订单单号20180821000033已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853036', '1', '0', '1534853036', ''), ('106', '27', '您的订单：订单单号20180821000031已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853090', '1', '0', '1534853090', ''), ('107', '27', '您的订单：订单单号20180821000030已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853110', '1', '0', '1534853110', ''), ('108', '27', '您的订单：订单单号20180821000029已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853123', '1', '0', '1534853123', ''), ('109', '27', '您的订单：订单单号20180821000028已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853133', '1', '0', '1534853133', ''), ('110', '27', '您的订单：订单单号20180821000027已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853145', '1', '0', '1534853145', ''), ('111', '27', '您的订单：订单单号20180821000026已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853157', '1', '0', '1534853157', ''), ('112', '27', '您的订单：订单单号20180821000025已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853215', '1', '0', '1534853215', ''), ('113', '27', '您的订单：订单单号20180821000017已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853575', '1', '0', '1534853575', ''), ('114', '27', '您的订单：订单单号20180821000018已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853588', '1', '0', '1534853588', ''), ('115', '27', '您的订单：订单单号20180821000019已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853603', '1', '0', '1534853603', ''), ('116', '27', '您的订单：订单单号20180821000020已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853612', '1', '0', '1534853612', ''), ('117', '27', '您的订单：订单单号20180821000022已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853622', '1', '0', '1534853622', ''), ('118', '27', '您的订单：订单单号20180821000023已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853624', '1', '0', '1534853624', ''), ('119', '27', '您的订单：订单单号20180821000024已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853627', '1', '0', '1534853627', ''), ('120', '27', '您的订单：订单单号20180821000021已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534853630', '1', '0', '1534853630', ''), ('121', '25', '登陆提示：您的会员superman于2018-08-21登陆成功！', '1534854339', '1', '0', '1534854339', ''), ('122', '27', '您的订单：订单单号20180821000055已于2018-08-21发货，运单号：1`23123123。请进入用户中心商品订单查看。', '1534854354', '1', '0', '1534854354', ''), ('123', '27', '您的订单：订单单号20180821000055已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534854380', '1', '0', '1534854380', ''), ('124', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534854532', '1', '0', '1534854532', ''), ('125', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534854645', '1', '0', '1534854645', ''), ('126', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534854770', '1', '0', '1534854770', ''), ('127', '2', '登陆提示：您的会员shoptnt于2018-08-21登陆成功！', '1534854980', '1', '0', '1534854980', ''), ('128', '16', '登陆提示：您的会员food于2018-08-21登陆成功！', '1534855380', '1', '0', '1534855380', ''), ('129', '25', '登陆提示：您的会员superman于2018-08-21登陆成功！', '1534855448', '1', '0', '1534855448', ''), ('130', '16', '您的订单：订单单号20180821000060已于2018-08-21发货，运单号：12312313。请进入用户中心商品订单查看。', '1534855459', '1', '0', '1534855459', ''), ('131', '16', '您的订单：订单单号20180821000060已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534855474', '1', '0', '1534855474', ''), ('132', '16', '您的订单：订单单号20180821000061已于2018-08-21发货，运单号：123123123。请进入用户中心商品订单查看。', '1534855523', '1', '0', '1534855523', ''), ('133', '16', '您的订单：订单单号20180821000062已于2018-08-21发货，运单号：123123123。请进入用户中心商品订单查看。', '1534855672', '1', '0', '1534855672', ''), ('134', '16', '您的订单：订单单号20180821000062已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534855760', '1', '0', '1534855760', ''), ('135', '16', '您的订单：订单单号20180821000064已于2018-08-21发货，运单号：123123。请进入用户中心商品订单查看。', '1534855869', '1', '0', '1534855869', ''), ('136', '16', '您的订单：订单单号20180821000064已于2018-08-21收货完成，请进入商户中心商品订单查看。', '1534856634', '1', '0', '1534856634', ''), ('137', '51', '登陆提示：您的会员m_18555555555于2018-08-21登陆成功！', '1534857464', '1', '0', '1534857464', ''), ('138', '27', '登陆提示：您的会员appliance于2018-08-21登陆成功！', '1534859889', '1', '0', '1534859889', ''), ('139', '2', '登陆提示：您的会员shoptnt于2018-08-21登陆成功！', '1534860033', '1', '0', '1534860033', ''), ('140', '2', '登陆提示：您的会员shoptnt于2018-08-21登陆成功！', '1534860054', '1', '0', '1534860054', ''), ('141', '27', '您的订单：订单单号20180821000056已于2018-08-22取消，请进入用户中心商品订单查看。', '1534867201', '1', '0', '1534867201', ''), ('142', '27', '您的订单：订单单号20180821000057已于2018-08-22取消，请进入用户中心商品订单查看。', '1534867201', '1', '0', '1534867201', ''), ('143', '27', '您的订单：订单单号20180821000058已于2018-08-22取消，请进入用户中心商品订单查看。', '1534867202', '1', '0', '1534867202', ''), ('144', '27', '您的订单：订单单号20180821000059已于2018-08-22取消，请进入用户中心商品订单查看。', '1534867202', '1', '0', '1534867202', ''), ('145', '50', '您的订单：订单单号20180821000002已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867202', '1', '0', '1534867202', ''), ('146', '50', '您的订单：订单单号20180821000003已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867203', '1', '0', '1534867203', ''), ('147', '50', '您的订单：订单单号20180821000004已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867203', '1', '0', '1534867203', ''), ('148', '50', '您的订单：订单单号20180821000005已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867203', '1', '0', '1534867203', ''), ('149', '50', '您的订单：订单单号20180821000006已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867204', '1', '0', '1534867204', ''), ('150', '50', '您的订单：订单单号20180821000007已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867204', '1', '0', '1534867204', ''), ('151', '50', '您的订单：订单单号20180821000008已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867204', '1', '0', '1534867204', ''), ('152', '50', '您的订单：订单单号20180821000009已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867204', '1', '0', '1534867204', ''), ('153', '50', '您的订单：订单单号20180821000010已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867205', '1', '0', '1534867205', ''), ('154', '50', '您的订单：订单单号20180821000011已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867205', '1', '0', '1534867205', ''), ('155', '50', '您的订单：订单单号20180821000012已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867205', '1', '0', '1534867205', ''), ('156', '50', '您的订单：订单单号20180821000013已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867205', '1', '0', '1534867205', ''), ('157', '50', '您的订单：订单单号20180821000014已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867206', '1', '0', '1534867206', ''), ('158', '50', '您的订单：订单单号20180821000015已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867206', '1', '0', '1534867206', ''), ('159', '50', '您的订单：订单单号20180821000016已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867206', '1', '0', '1534867206', ''), ('160', '46', '您的订单：订单单号20180821000049已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867206', '1', '0', '1534867206', ''), ('161', '46', '您的订单：订单单号20180821000051已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867207', '1', '0', '1534867207', ''), ('162', '46', '您的订单：订单单号20180821000052已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867207', '1', '0', '1534867207', ''), ('163', '46', '您的订单：订单单号20180821000053已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867207', '1', '0', '1534867207', ''), ('164', '46', '您的订单：订单单号20180821000054已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867207', '1', '0', '1534867207', ''), ('165', '2', '您的订单：订单单号20180821000061已于2018-08-22收货完成，请进入商户中心商品订单查看。', '1534867208', '1', '0', '1534867208', ''), ('166', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534900699', '1', '0', '1534900699', ''), ('167', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534900733', '1', '0', '1534900733', ''), ('168', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534900755', '1', '0', '1534900755', ''), ('169', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534909062', '1', '0', '1534909062', ''), ('170', '51', '登陆提示：您的会员m_18555555555于2018-08-22登陆成功！', '1534909106', '1', '0', '1534909106', ''), ('171', '51', '登陆提示：您的会员m_18555555555于2018-08-22登陆成功！', '1534909108', '1', '0', '1534909108', ''), ('172', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534909320', '1', '0', '1534909320', ''), ('173', '51', '登陆提示：您的会员m_18555555555于2018-08-22登陆成功！', '1534909367', '1', '0', '1534909367', ''), ('174', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534909482', '1', '0', '1534909482', ''), ('175', '51', '登陆提示：您的会员m_18555555555于2018-08-22登陆成功！', '1534909552', '1', '0', '1534909552', ''), ('176', '27', '登陆提示：您的会员appliance于2018-08-22登陆成功！', '1534910770', '1', '0', '1534910770', ''), ('177', '51', '登陆提示：您的会员m_18555555555于2018-08-22登陆成功！', '1534910943', '1', '0', '1534910943', ''), ('178', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534911413', '1', '0', '1534911413', ''), ('179', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534911626', '1', '0', '1534911626', ''), ('180', '52', '登陆提示：您的会员fengkun于2018-08-22登陆成功！', '1534917930', '1', '0', '1534917930', ''), ('181', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534917971', '1', '0', '1534917971', ''), ('182', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534917994', '1', '0', '1534917994', ''), ('183', '51', '登陆提示：您的会员m_18555555555于2018-08-22登陆成功！', '1534918206', '1', '0', '1534918206', ''), ('184', '52', '登陆提示：您的会员fengkun于2018-08-22登陆成功！', '1534918595', '1', '0', '1534918595', ''), ('185', '27', '登陆提示：您的会员appliance于2018-08-22登陆成功！', '1534918689', '1', '0', '1534918689', ''), ('186', '2', '登陆提示：您的会员shoptnt于2018-08-22登陆成功！', '1534918721', '1', '0', '1534918721', ''), ('187', '27', '登陆提示：您的会员appliance于2018-08-22登陆成功！', '1534919951', '1', '0', '1534919951', ''), ('188', '27', '登陆提示：您的会员appliance于2018-08-22登陆成功！', '1534919958', '1', '0', '1534919958', ''), ('189', '27', '登陆提示：您的会员appliance于2018-08-22登陆成功！', '1534919960', '1', '0', '1534919960', ''), ('190', '27', '登陆提示：您的会员appliance于2018-08-22登陆成功！', '1534919961', '1', '0', '1534919961', ''), ('191', '2', '登陆提示：您的会员shoptnt于2018-08-22登陆成功！', '1534924195', '1', '0', '1534924195', ''), ('192', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534928231', '1', '0', '1534928231', ''), ('193', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534928253', '1', '0', '1534928253', ''), ('194', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534928289', '1', '0', '1534928289', ''), ('195', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534930985', '1', '0', '1534930985', ''), ('196', '16', '登陆提示：您的会员food于2018-08-22登陆成功！', '1534932555', '1', '0', '1534932555', ''), ('197', '51', '登陆提示：您的会员m_18555555555于2018-08-22登陆成功！', '1534936020', '1', '0', '1534936020', ''), ('198', '51', '您的订单：订单单号20180822000001已于2018-08-23取消，请进入用户中心商品订单查看。', '1534953602', '1', '0', '1534953602', ''), ('199', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534991050', '1', '0', '1534991050', ''), ('200', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534992658', '1', '0', '1534992658', ''), ('201', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534992666', '1', '0', '1534992666', ''), ('202', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534992705', '1', '0', '1534992705', ''), ('203', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534992732', '1', '0', '1534992732', ''), ('204', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534993164', '1', '0', '1534993164', ''), ('205', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534993429', '1', '0', '1534993429', ''), ('206', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534993497', '1', '0', '1534993497', ''), ('207', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534993633', '1', '0', '1534993633', ''), ('208', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534993813', '1', '0', '1534993813', ''), ('209', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534994033', '1', '0', '1534994033', ''), ('210', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534995053', '1', '0', '1534995053', ''), ('211', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534995065', '1', '0', '1534995065', ''), ('212', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534995683', '1', '0', '1534995683', ''), ('213', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1534996177', '1', '0', '1534996177', ''), ('214', '27', '登陆提示：您的会员appliance于2018-08-23登陆成功！', '1535004880', '1', '0', '1535004880', ''), ('215', '51', '您的订单：订单单号20180823000001已于2018-08-23发货，运单号：F00004261095。请进入用户中心商品订单查看。', '1535004912', '1', '0', '1535004912', ''), ('216', '51', '您的订单：订单单号20180823000001已于2018-08-23收货完成，请进入商户中心商品订单查看。', '1535004992', '1', '0', '1535004992', ''), ('217', '51', '您的订单：订单单号20180823000002已于2018-08-23发货，运单号：asasasas。请进入用户中心商品订单查看。', '1535005377', '1', '0', '1535005377', ''), ('218', '51', '您的订单：订单单号20180823000002已于2018-08-23收货完成，请进入商户中心商品订单查看。', '1535005396', '1', '0', '1535005396', ''), ('219', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535005515', '1', '0', '1535005515', ''), ('220', '16', '您的订单：订单单号20180823000003已于2018-08-23发货，运单号：221398681923。请进入用户中心商品订单查看。', '1535005922', '1', '0', '1535005922', ''), ('221', '27', '登陆提示：您的会员appliance于2018-08-23登陆成功！', '1535010135', '1', '0', '1535010135', ''), ('222', '51', '登陆提示：您的会员m_18555555555于2018-08-23登陆成功！', '1535010526', '1', '0', '1535010526', ''), ('223', '27', '登陆提示：您的会员appliance于2018-08-23登陆成功！', '1535011737', '1', '0', '1535011737', ''), ('224', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535015258', '1', '0', '1535015258', ''), ('225', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535016343', '1', '0', '1535016343', ''), ('226', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535016715', '1', '0', '1535016715', ''), ('227', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535017506', '1', '0', '1535017506', ''), ('228', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535017999', '1', '0', '1535017999', ''), ('229', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535018881', '1', '0', '1535018881', ''), ('230', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535018906', '1', '0', '1535018906', ''), ('231', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535019495', '1', '0', '1535019495', ''), ('232', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535019617', '1', '0', '1535019617', ''), ('233', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535019919', '1', '0', '1535019919', ''), ('234', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535020790', '1', '0', '1535020790', ''), ('235', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535028583', '1', '0', '1535028583', ''), ('236', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535028603', '1', '0', '1535028603', ''), ('237', '51', '登陆提示：您的会员m_18555555555于2018-08-23登陆成功！', '1535033732', '1', '0', '1535033732', ''), ('238', '51', '登陆提示：您的会员m_18555555555于2018-08-23登陆成功！', '1535033906', '1', '0', '1535033906', ''), ('239', '16', '登陆提示：您的会员food于2018-08-23登陆成功！', '1535034154', '1', '0', '1535034154', ''), ('240', '51', '您的订单：订单单号20180823000115已于2018-08-23发货，运单号：1234。请进入用户中心商品订单查看。', '1535034180', '1', '0', '1535034180', ''), ('241', '16', '您的订单：订单单号20180823000003已于2018-08-24收货完成，请进入商户中心商品订单查看。', '1535040001', '1', '0', '1535040001', ''), ('242', '51', '您的订单：订单单号20180823000115已于2018-08-24收货完成，请进入商户中心商品订单查看。', '1535040002', '1', '0', '1535040002', ''), ('243', '51', '登陆提示：您的会员m_18555555555于2018-08-24登陆成功！', '1535075722', '1', '0', '1535075722', ''), ('244', '27', '登陆提示：您的会员appliance于2018-08-24登陆成功！', '1535076355', '1', '0', '1535076355', ''), ('245', '2', '登陆提示：您的会员shoptnt于2018-08-24登陆成功！', '1535100914', '1', '0', '1535100914', ''), ('246', '52', '登陆提示：您的会员fengkun于2018-08-24登陆成功！', '1535100977', '1', '0', '1535100977', ''), ('247', '27', '登陆提示：您的会员appliance于2018-08-24登陆成功！', '1535106854', '1', '0', '1535106854', ''), ('248', '52', '您的订单：订单单号20180824000233已于2018-08-25取消，请进入用户中心商品订单查看。', '1535126401', '1', '0', '1535126401', ''), ('249', '2', '登陆提示：您的会员shoptnt于2018-08-26登陆成功！', '1535283181', '1', '0', '1535283181', ''), ('250', '2', '登陆提示：您的会员shoptnt于2018-08-26登陆成功！', '1535283212', '1', '0', '1535283212', ''), ('251', '2', '登陆提示：您的会员shoptnt于2018-08-26登陆成功！', '1535284070', '1', '0', '1535284070', ''), ('252', '26', '登陆提示：您的会员kans于2018-08-27登陆成功！', '1535338916', '1', '1', '1535338916', ''), ('253', '27', '登陆提示：您的会员appliance于2018-08-27登陆成功！', '1535339051', '1', '0', '1535339051', ''), ('254', '25', '登陆提示：您的会员superman于2018-08-27登陆成功！', '1535339154', '1', '0', '1535339154', ''), ('255', '26', '登陆提示：您的会员kans于2018-08-27登陆成功！', '1535339264', '1', '1', '1535339264', ''), ('256', '16', '登陆提示：您的会员shoptnt于2018-08-27登陆成功！', '1535340642', '1', '0', '1535340642', ''), ('257', '16', '登陆提示：您的会员shoptnt于2018-08-27登陆成功！', '1535340662', '1', '0', '1535340662', ''), ('258', '53', '登陆提示：您的会员chopper于2018-08-27登陆成功！', '1535340715', '1', '0', '1535340715', ''), ('259', '53', '您的订单：订单单号20180827000001已于2018-08-27取消，请进入用户中心商品订单查看。', '1535341058', '1', '0', '1535341058', ''), ('260', '16', '登陆提示：您的会员shoptnt于2018-08-27登陆成功！', '1535341170', '1', '0', '1535341170', ''), ('261', '26', '登陆提示：您的会员kans于2018-08-27登陆成功！', '1535344197', '1', '1', '1535344197', ''), ('262', '27', '登陆提示：您的会员appliance于2018-08-27登陆成功！', '1535344209', '1', '0', '1535344209', ''), ('263', '26', '登陆提示：您的会员kans于2018-08-27登陆成功！', '1535344449', '1', '1', '1535344449', ''), ('264', '2', '登陆提示：您的会员shoptnt于2018-08-27登陆成功！', '1535353721', '1', '0', '1535353721', ''), ('265', '2', '登陆提示：您的会员shoptnt于2018-08-27登陆成功！', '1535366292', '1', '0', '1535366292', ''), ('266', '26', '登陆提示：您的会员kans于2018-08-27登陆成功！', '1535367864', '0', '1', '1535367864', ''), ('267', '2', '登陆提示：您的会员shoptnt于2018-08-27登陆成功！', '1535370963', '1', '0', '1535370963', ''), ('268', '27', '登陆提示：您的会员appliance于2018-08-28登陆成功！', '1535418382', '1', '0', '1535418382', ''), ('269', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535419187', '1', '0', '1535419187', ''), ('270', '27', '登陆提示：您的会员appliance于2018-08-28登陆成功！', '1535419280', '1', '0', '1535419280', ''), ('271', '25', '登陆提示：您的会员superman于2018-08-28登陆成功！', '1535419460', '1', '0', '1535419460', ''), ('272', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535427695', '1', '0', '1535427695', ''), ('273', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535429804', '1', '0', '1535429804', ''), ('274', '27', '登陆提示：您的会员appliance于2018-08-28登陆成功！', '1535437526', '1', '0', '1535437526', ''), ('275', '47', '登陆提示：您的会员black于2018-08-28登陆成功！', '1535438520', '1', '0', '1535438520', ''), ('276', '54', '登陆提示：您的会员AAA于2018-08-28登陆成功！', '1535442163', '1', '0', '1535442163', ''), ('277', '27', '登陆提示：您的会员appliance于2018-08-28登陆成功！', '1535442788', '1', '0', '1535442788', ''), ('278', '55', '登陆提示：您的会员shoptnt7于2018-08-28登陆成功！', '1535443163', '1', '0', '1535443163', ''), ('279', '2', '登陆提示：您的会员shoptnt于2018-08-28登陆成功！', '1535444112', '1', '0', '1535444112', ''), ('280', '2', '登陆提示：您的会员shoptnt于2018-08-28登陆成功！', '1535444238', '1', '0', '1535444238', ''), ('281', '2', '登陆提示：您的会员shoptnt于2018-08-28登陆成功！', '1535444562', '1', '0', '1535444562', ''), ('282', '46', '登陆提示：您的会员blue于2018-08-28登陆成功！', '1535445904', '1', '0', '1535445904', ''), ('283', '2', '登陆提示：您的会员shoptnt于2018-08-28登陆成功！', '1535446236', '1', '0', '1535446236', ''), ('284', '46', '登陆提示：您的会员blue于2018-08-28登陆成功！', '1535447809', '1', '0', '1535447809', ''), ('285', '55', '登陆提示：您的会员shoptnt7于2018-08-28登陆成功！', '1535447868', '1', '0', '1535447868', ''), ('286', '56', '登陆提示：您的会员aaaa于2018-08-28登陆成功！', '1535448004', '1', '0', '1535448004', ''), ('287', '57', '登陆提示：您的会员testo于2018-08-28登陆成功！', '1535448163', '1', '0', '1535448163', ''), ('288', '58', '登陆提示：您的会员test123于2018-08-28登陆成功！', '1535448295', '1', '0', '1535448295', ''), ('289', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535448671', '1', '0', '1535448671', ''), ('290', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535448685', '1', '0', '1535448685', ''), ('291', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535448828', '1', '0', '1535448828', ''), ('292', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535450021', '1', '0', '1535450021', ''), ('293', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535450036', '1', '0', '1535450036', ''), ('294', '2', '登陆提示：您的会员shoptnt于2018-08-28登陆成功！', '1535451048', '1', '0', '1535451048', ''), ('295', '2', '登陆提示：您的会员shoptnt于2018-08-28登陆成功！', '1535451467', '1', '0', '1535451467', ''), ('296', '55', '登陆提示：您的会员shoptnt7于2018-08-28登陆成功！', '1535453191', '1', '0', '1535453191', ''), ('297', '55', '登陆提示：您的会员shoptnt7于2018-08-28登陆成功！', '1535453613', '1', '0', '1535453613', ''), ('298', '55', '登陆提示：您的会员shoptnt7于2018-08-28登陆成功！', '1535453648', '1', '0', '1535453648', ''), ('299', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535454119', '1', '0', '1535454119', ''), ('300', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535454142', '1', '0', '1535454142', ''), ('301', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535457410', '1', '0', '1535457410', ''), ('302', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535457509', '1', '0', '1535457509', ''), ('303', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535457826', '1', '0', '1535457826', ''), ('304', '26', '登陆提示：您的会员kans于2018-08-28登陆成功！', '1535457890', '1', '0', '1535457890', ''), ('305', '2', '登陆提示：您的会员shoptnt于2018-08-28登陆成功！', '1535462771', '1', '0', '1535462771', ''), ('306', '27', '登陆提示：您的会员appliance于2018-08-28登陆成功！', '1535462871', '1', '0', '1535462871', ''), ('307', '27', '您的订单：订单单号20180828000066已于2018-08-28取消，请进入用户中心商品订单查看。', '1535462984', '1', '0', '1535462984', ''), ('308', '25', '登陆提示：您的会员superman于2018-08-29登陆成功！', '1535504609', '1', '0', '1535504609', ''), ('309', '25', '登陆提示：您的会员superman于2018-08-29登陆成功！', '1535504650', '1', '0', '1535504650', ''), ('310', '27', '登陆提示：您的会员appliance于2018-08-29登陆成功！', '1535505893', '1', '0', '1535505893', ''), ('311', '55', '登陆提示：您的会员shoptnt7于2018-08-29登陆成功！', '1535507093', '1', '0', '1535507093', ''), ('312', '2', '登陆提示：您的会员shoptnt于2018-08-29登陆成功！', '1535509769', '1', '0', '1535509769', ''), ('313', '2', '登陆提示：您的会员shoptnt于2018-08-29登陆成功！', '1535510259', '1', '0', '1535510259', ''), ('314', '2', '登陆提示：您的会员shoptnt于2018-08-29登陆成功！', '1535510276', '1', '0', '1535510276', ''), ('315', '2', '登陆提示：您的会员shoptnt于2018-09-04登陆成功！', '1536046991', '1', '0', '1536046991', ''), ('316', '45', '登陆提示：您的会员green于2018-09-07登陆成功！', '1536301632', '1', '0', '1536301632', ''), ('317', '16', '登陆提示：您的会员food于2018-09-07登陆成功！', '1536303850', '1', '0', '1536303850', ''), ('318', '45', '登陆提示：您的会员green于2018-12-25登陆成功！', '1545731873', '1', '0', '1545731873', ''), ('319', '45', '您的订单：订单单号20181225000001已于2018-12-25发货，运单号：346345346。请进入用户中心商品订单查看。', '1545731983', '1', '0', '1545731983', ''), ('320', '45', '您的订单：订单单号20181225000001已于2018-12-25收货完成，请进入商户中心商品订单查看。', '1545731995', '1', '0', '1545731995', ''), ('321', '45', '登陆提示：您的会员green于2018-12-25登陆成功！', '1545734329', '1', '0', '1545734329', ''), ('322', '45', '登陆提示：您的会员green于2018-12-25登陆成功！', '1545734441', '1', '0', '1545734441', '');
COMMIT;

-- ----------------------------
--  Table structure for `es_member_point_history`
-- ----------------------------
DROP TABLE IF EXISTS `es_member_point_history`;
CREATE TABLE `es_member_point_history` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `member_id` int(10) DEFAULT NULL COMMENT '会员ID',
  `grade_point` bigint(20) DEFAULT NULL COMMENT '等级积分',
  `time` bigint(20) DEFAULT NULL COMMENT '操作时间',
  `reason` varchar(255) DEFAULT NULL COMMENT '操作理由',
  `grade_point_type` int(2) DEFAULT NULL COMMENT '等级积分类型',
  `operator` varchar(255) DEFAULT NULL COMMENT '操作者',
  `consum_point` bigint(20) DEFAULT NULL COMMENT '消费积分',
  `consum_point_type` int(2) DEFAULT NULL COMMENT '消费积分类型',
  PRIMARY KEY (`id`),
  KEY `ind_ponit_history` (`member_id`,`grade_point_type`,`consum_point_type`)
) ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8 COMMENT='会员积分表(es_member_point_history)';

-- ----------------------------
--  Records of `es_member_point_history`
-- ----------------------------
BEGIN;
INSERT INTO `es_member_point_history` VALUES ('1', '51', '1', '1534837036', '每天首次登录送积分', '1', '系统', '1', '1'), ('2', '16', '1', '1534837112', '每天首次登录送积分', '1', '系统', '1', '1'), ('3', '25', '1', '1534840100', '每天首次登录送积分', '1', '系统', '1', '1'), ('4', '27', '1', '1534840361', '每天首次登录送积分', '1', '系统', '1', '1'), ('5', '50', '1', '1534847138', '每天首次登录送积分', '1', '系统', '1', '1'), ('6', '50', '0', '1534847476', '创建订单，消费积分', '0', '回到过去', '1500', '0'), ('7', '50', '1', '1534847495', '在线支付送积分', '1', '系统', '1', '1'), ('8', '50', '1', '1534847503', '在线支付送积分', '1', '系统', '1', '1'), ('9', '50', '1', '1534847510', '在线支付送积分', '1', '系统', '1', '1'), ('10', '50', '1', '1534847519', '在线支付送积分', '1', '系统', '1', '1'), ('11', '50', '1', '1534847526', '在线支付送积分', '1', '系统', '1', '1'), ('12', '50', '1', '1534847539', '在线支付送积分', '1', '系统', '1', '1'), ('13', '50', '1', '1534847551', '在线支付送积分', '1', '系统', '1', '1'), ('14', '50', '1', '1534847559', '在线支付送积分', '1', '系统', '1', '1'), ('15', '50', '1', '1534847566', '在线支付送积分', '1', '系统', '1', '1'), ('16', '50', '1', '1534847579', '在线支付送积分', '1', '系统', '1', '1'), ('17', '16', '1', '1534847589', '在线支付送积分', '1', '系统', '1', '1'), ('18', '50', '1', '1534847595', '在线支付送积分', '1', '系统', '1', '1'), ('19', '50', '1', '1534847605', '在线支付送积分', '1', '系统', '1', '1'), ('20', '50', '1', '1534847611', '在线支付送积分', '1', '系统', '1', '1'), ('21', '50', '1', '1534847616', '在线支付送积分', '1', '系统', '1', '1'), ('22', '50', '1', '1534847624', '在线支付送积分', '1', '系统', '1', '1'), ('23', '27', '1', '1534848168', '在线支付送积分', '1', '系统', '1', '1'), ('24', '27', '1', '1534848175', '在线支付送积分', '1', '系统', '1', '1'), ('25', '27', '1', '1534848181', '在线支付送积分', '1', '系统', '1', '1'), ('26', '27', '1', '1534848186', '在线支付送积分', '1', '系统', '1', '1'), ('27', '27', '1', '1534848191', '在线支付送积分', '1', '系统', '1', '1'), ('28', '27', '1', '1534848196', '在线支付送积分', '1', '系统', '1', '1'), ('29', '27', '1', '1534848201', '在线支付送积分', '1', '系统', '1', '1'), ('30', '27', '1', '1534848206', '在线支付送积分', '1', '系统', '1', '1'), ('31', '27', '1', '1534848211', '在线支付送积分', '1', '系统', '1', '1'), ('32', '27', '1', '1534848218', '在线支付送积分', '1', '系统', '1', '1'), ('33', '27', '1', '1534848225', '在线支付送积分', '1', '系统', '1', '1'), ('34', '27', '1', '1534848230', '在线支付送积分', '1', '系统', '1', '1'), ('35', '27', '1', '1534848235', '在线支付送积分', '1', '系统', '1', '1'), ('36', '27', '1', '1534848240', '在线支付送积分', '1', '系统', '1', '1'), ('37', '27', '1', '1534848245', '在线支付送积分', '1', '系统', '1', '1'), ('38', '27', '1', '1534848251', '在线支付送积分', '1', '系统', '1', '1'), ('39', '27', '1', '1534848260', '在线支付送积分', '1', '系统', '1', '1'), ('40', '27', '1', '1534848265', '在线支付送积分', '1', '系统', '1', '1'), ('41', '27', '1', '1534848270', '在线支付送积分', '1', '系统', '1', '1'), ('42', '27', '1', '1534848275', '在线支付送积分', '1', '系统', '1', '1'), ('43', '2', '1', '1534848992', '每天首次登录送积分', '1', '系统', '1', '1'), ('44', '16', '1', '1534849544', '在线支付送积分', '1', '系统', '1', '1'), ('45', '16', '1', '1534849567', '在线支付送积分', '1', '系统', '1', '1'), ('46', '16', '1', '1534849574', '在线支付送积分', '1', '系统', '1', '1'), ('47', '16', '1', '1534849579', '在线支付送积分', '1', '系统', '1', '1'), ('48', '27', '1', '1534849585', '在线支付送积分', '1', '系统', '1', '1'), ('49', '27', '1', '1534849590', '在线支付送积分', '1', '系统', '1', '1'), ('50', '27', '1', '1534849595', '在线支付送积分', '1', '系统', '1', '1'), ('51', '27', '1', '1534849600', '在线支付送积分', '1', '系统', '1', '1'), ('52', '27', '1', '1534849605', '在线支付送积分', '1', '系统', '1', '1'), ('53', '27', '1', '1534849610', '在线支付送积分', '1', '系统', '1', '1'), ('54', '27', '1', '1534849615', '在线支付送积分', '1', '系统', '1', '1'), ('55', '27', '1', '1534849624', '在线支付送积分', '1', '系统', '1', '1'), ('56', '46', '1', '1534849708', '每天首次登录送积分', '1', '系统', '1', '1'), ('57', '46', '1', '1534849824', '在线支付送积分', '1', '系统', '1', '1'), ('58', '46', '1', '1534849829', '在线支付送积分', '1', '系统', '1', '1'), ('59', '46', '1', '1534849834', '在线支付送积分', '1', '系统', '1', '1'), ('60', '46', '1', '1534849839', '在线支付送积分', '1', '系统', '1', '1'), ('61', '46', '1', '1534849844', '在线支付送积分', '1', '系统', '1', '1'), ('62', '46', '1', '1534849848', '在线支付送积分', '1', '系统', '1', '1'), ('63', '11', '1', '1534852395', '每天首次登录送积分', '1', '系统', '1', '1'), ('64', '6', '1', '1534852504', '每天首次登录送积分', '1', '系统', '1', '1'), ('65', '26', '1', '1534852535', '每天首次登录送积分', '1', '系统', '1', '1'), ('66', '16', '1', '1534852799', '文字评论送积分', '1', '系统', '1', '1'), ('67', '16', '1', '1534852799', '文字评论送积分', '1', '系统', '1', '1'), ('68', '16', '1', '1534852812', '文字评论送积分', '1', '系统', '1', '1'), ('69', '16', '1', '1534852822', '文字评论送积分', '1', '系统', '1', '1'), ('70', '16', '1', '1534852831', '文字评论送积分', '1', '系统', '1', '1'), ('71', '16', '1', '1534852839', '文字评论送积分', '1', '系统', '1', '1'), ('72', '16', '10', '1534852839', '每个商品首次评论', '1', '系统', '10', '1'), ('73', '27', '1', '1534852917', '文字评论送积分', '1', '系统', '1', '1'), ('74', '27', '1', '1534852925', '文字评论送积分', '1', '系统', '1', '1'), ('75', '27', '1', '1534852933', '文字评论送积分', '1', '系统', '1', '1'), ('76', '27', '1', '1534852942', '文字评论送积分', '1', '系统', '1', '1'), ('77', '27', '1', '1534852950', '文字评论送积分', '1', '系统', '1', '1'), ('78', '27', '10', '1534852950', '每个商品首次评论', '1', '系统', '10', '1'), ('79', '27', '1', '1534852963', '文字评论送积分', '1', '系统', '1', '1'), ('80', '27', '1', '1534852978', '文字评论送积分', '1', '系统', '1', '1'), ('81', '27', '1', '1534852993', '文字评论送积分', '1', '系统', '1', '1'), ('82', '27', '1', '1534853006', '文字评论送积分', '1', '系统', '1', '1'), ('83', '27', '10', '1534853006', '每个商品首次评论', '1', '系统', '10', '1'), ('84', '27', '1', '1534853006', '文字评论送积分', '1', '系统', '1', '1'), ('85', '27', '1', '1534853006', '文字评论送积分', '1', '系统', '1', '1'), ('86', '27', '1', '1534853006', '文字评论送积分', '1', '系统', '1', '1'), ('87', '27', '1', '1534853024', '文字评论送积分', '1', '系统', '1', '1'), ('88', '27', '10', '1534853024', '每个商品首次评论', '1', '系统', '10', '1'), ('89', '27', '1', '1534853024', '文字评论送积分', '1', '系统', '1', '1'), ('90', '27', '1', '1534853024', '文字评论送积分', '1', '系统', '1', '1'), ('91', '27', '1', '1534853024', '文字评论送积分', '1', '系统', '1', '1'), ('92', '27', '1', '1534853024', '文字评论送积分', '1', '系统', '1', '1'), ('93', '27', '1', '1534853024', '文字评论送积分', '1', '系统', '1', '1'), ('94', '27', '1', '1534853097', '文字评论送积分', '1', '系统', '1', '1'), ('95', '27', '1', '1534853116', '文字评论送积分', '1', '系统', '1', '1'), ('96', '27', '1', '1534853116', '文字评论送积分', '1', '系统', '1', '1'), ('97', '27', '1', '1534853126', '文字评论送积分', '1', '系统', '1', '1'), ('98', '27', '1', '1534853136', '文字评论送积分', '1', '系统', '1', '1'), ('99', '27', '1', '1534853150', '文字评论送积分', '1', '系统', '1', '1'), ('100', '27', '1', '1534853162', '文字评论送积分', '1', '系统', '1', '1'), ('101', '27', '1', '1534853162', '文字评论送积分', '1', '系统', '1', '1'), ('102', '27', '1', '1534853584', '文字评论送积分', '1', '系统', '1', '1'), ('103', '27', '1', '1534853592', '文字评论送积分', '1', '系统', '1', '1'), ('104', '27', '1', '1534853606', '文字评论送积分', '1', '系统', '1', '1'), ('105', '27', '1', '1534853616', '文字评论送积分', '1', '系统', '1', '1'), ('106', '27', '10', '1534853616', '每个商品首次评论', '1', '系统', '10', '1'), ('107', '27', '1', '1534853638', '文字评论送积分', '1', '系统', '1', '1'), ('108', '27', '1', '1534854198', '在线支付送积分', '1', '系统', '1', '1'), ('109', '16', '1', '1534855418', '在线支付送积分', '1', '系统', '1', '1'), ('110', '16', '1', '1534855509', '在线支付送积分', '1', '系统', '1', '1'), ('111', '16', '1', '1534855656', '在线支付送积分', '1', '系统', '1', '1'), ('112', '16', '1', '1534855805', '在线支付送积分', '1', '系统', '1', '1'), ('113', '16', '1', '1534855850', '在线支付送积分', '1', '系统', '1', '1'), ('114', '27', '1', '1534860204', '在线支付送积分', '1', '系统', '1', '1'), ('115', '27', '0', '1534867201', '订单取消，退还消费积分', '0', 'appliance', '0', '1'), ('116', '27', '0', '1534867201', '订单取消，退还消费积分', '0', 'appliance', '0', '1'), ('117', '27', '0', '1534867202', '订单取消，退还消费积分', '0', 'appliance', '0', '1'), ('118', '27', '0', '1534867202', '订单取消，退还消费积分', '0', 'appliance', '0', '1'), ('119', '16', '67', '1534867208', '购买商品送积分', '1', '系统', '67', '1'), ('120', '27', '1049', '1534867208', '购买商品送积分', '1', '系统', '1049', '1'), ('121', '27', '2999', '1534867208', '购买商品送积分', '1', '系统', '2999', '1'), ('122', '27', '3699', '1534867208', '购买商品送积分', '1', '系统', '3699', '1'), ('123', '27', '1299', '1534867208', '购买商品送积分', '1', '系统', '1299', '1'), ('124', '27', '2599', '1534867209', '购买商品送积分', '1', '系统', '2599', '1'), ('125', '27', '4198', '1534867209', '购买商品送积分', '1', '系统', '4198', '1'), ('126', '27', '399', '1534867209', '购买商品送积分', '1', '系统', '399', '1'), ('127', '27', '6798', '1534867209', '购买商品送积分', '1', '系统', '6798', '1'), ('128', '27', '399', '1534867210', '购买商品送积分', '1', '系统', '399', '1'), ('129', '27', '10198', '1534867210', '购买商品送积分', '1', '系统', '10198', '1'), ('130', '27', '1738', '1534867210', '购买商品送积分', '1', '系统', '1738', '1'), ('131', '27', '3699', '1534867210', '购买商品送积分', '1', '系统', '3699', '1'), ('132', '27', '120', '1534867210', '购买商品送积分', '1', '系统', '120', '1'), ('133', '27', '1778', '1534867211', '购买商品送积分', '1', '系统', '1778', '1'), ('134', '27', '4799', '1534867211', '购买商品送积分', '1', '系统', '4799', '1'), ('135', '27', '19337', '1534867211', '购买商品送积分', '1', '系统', '19337', '1'), ('136', '27', '62861', '1534867211', '购买商品送积分', '1', '系统', '62861', '1'), ('137', '27', '4556', '1534867212', '购买商品送积分', '1', '系统', '4556', '1'), ('138', '27', '385', '1534867212', '购买商品送积分', '1', '系统', '385', '1'), ('139', '27', '25', '1534867212', '购买商品送积分', '1', '系统', '25', '1'), ('140', '27', '58', '1534867212', '购买商品送积分', '1', '系统', '58', '1'), ('141', '27', '198', '1534867213', '购买商品送积分', '1', '系统', '198', '1'), ('142', '27', '135', '1534867213', '购买商品送积分', '1', '系统', '135', '1'), ('143', '27', '59', '1534867213', '购买商品送积分', '1', '系统', '59', '1'), ('144', '27', '996', '1534867213', '购买商品送积分', '1', '系统', '996', '1'), ('145', '27', '239', '1534867213', '购买商品送积分', '1', '系统', '239', '1'), ('146', '16', '199', '1534867213', '购买商品送积分', '1', '系统', '199', '1'), ('147', '16', '6184', '1534867213', '购买商品送积分', '1', '系统', '6184', '1'), ('148', '16', '159', '1534867214', '购买商品送积分', '1', '系统', '159', '1'), ('149', '16', '18447', '1534867214', '购买商品送积分', '1', '系统', '18447', '1'), ('150', '27', '519', '1534867214', '购买商品送积分', '1', '系统', '519', '1'), ('151', '16', '25', '1534867214', '购买商品送积分', '1', '系统', '25', '1'), ('152', '16', '77', '1534867214', '购买商品送积分', '1', '系统', '77', '1'), ('153', '16', '31', '1534867215', '购买商品送积分', '1', '系统', '31', '1'), ('154', '16', '1', '1534900699', '每天首次登录送积分', '1', '系统', '1', '1'), ('155', '51', '1', '1534909106', '每天首次登录送积分', '1', '系统', '1', '1'), ('156', '27', '1', '1534910770', '每天首次登录送积分', '1', '系统', '1', '1'), ('157', '52', '1', '1534917930', '每天首次登录送积分', '1', '系统', '1', '1'), ('158', '2', '1', '1534918721', '每天首次登录送积分', '1', '系统', '1', '1'), ('159', '51', '0', '1534953602', '订单取消，退还消费积分', '0', 'm_18555555555', '0', '1'), ('160', '50', '6099', '1534953603', '购买商品送积分', '1', '系统', '6099', '1'), ('161', '50', '1596', '1534953603', '购买商品送积分', '1', '系统', '1596', '1'), ('162', '50', '2299', '1534953603', '购买商品送积分', '1', '系统', '2299', '1'), ('163', '50', '189', '1534953603', '购买商品送积分', '1', '系统', '189', '1'), ('164', '50', '2299', '1534953604', '购买商品送积分', '1', '系统', '2299', '1'), ('165', '50', '3697', '1534953604', '购买商品送积分', '1', '系统', '3697', '1'), ('166', '50', '1199', '1534953604', '购买商品送积分', '1', '系统', '1199', '1'), ('167', '50', '2997', '1534953604', '购买商品送积分', '1', '系统', '2997', '1'), ('168', '50', '3182', '1534953605', '购买商品送积分', '1', '系统', '3182', '1'), ('169', '50', '6486', '1534953605', '购买商品送积分', '1', '系统', '6486', '1'), ('170', '50', '11997', '1534953605', '购买商品送积分', '1', '系统', '11997', '1'), ('171', '50', '11999', '1534953605', '购买商品送积分', '1', '系统', '11999', '1'), ('172', '50', '15', '1534953605', '购买商品送积分', '1', '系统', '15', '1'), ('173', '50', '22597', '1534953606', '购买商品送积分', '1', '系统', '22597', '1'), ('174', '50', '249', '1534953606', '购买商品送积分', '1', '系统', '249', '1'), ('175', '46', '4788', '1534953606', '购买商品送积分', '1', '系统', '4788', '1'), ('176', '46', '16495', '1534953606', '购买商品送积分', '1', '系统', '16495', '1'), ('177', '46', '3897', '1534953607', '购买商品送积分', '1', '系统', '3897', '1'), ('178', '46', '429', '1534953607', '购买商品送积分', '1', '系统', '429', '1'), ('179', '46', '4022', '1534953607', '购买商品送积分', '1', '系统', '4022', '1'), ('180', '2', '25', '1534953607', '购买商品送积分', '1', '系统', '25', '1'), ('181', '16', '1', '1534991050', '每天首次登录送积分', '1', '系统', '1', '1'), ('182', '51', '1', '1535004837', '在线支付送积分', '1', '系统', '1', '1'), ('183', '27', '1', '1535004880', '每天首次登录送积分', '1', '系统', '1', '1'), ('184', '51', '1', '1535005135', '图片评论送积分', '1', '系统', '1', '1'), ('185', '51', '1', '1535005365', '在线支付送积分', '1', '系统', '1', '1'), ('186', '51', '1', '1535005451', '图片评论送积分', '1', '系统', '1', '1'), ('187', '16', '1', '1535005824', '在线支付送积分', '1', '系统', '1', '1'), ('188', '51', '1', '1535010526', '每天首次登录送积分', '1', '系统', '1', '1'), ('189', '51', '999', '1535040002', '购买商品送积分', '1', '系统', '999', '1'), ('190', '51', '999', '1535040002', '购买商品送积分', '1', '系统', '999', '1'), ('191', '51', '1', '1535075722', '每天首次登录送积分', '1', '系统', '1', '1'), ('192', '27', '1', '1535076356', '每天首次登录送积分', '1', '系统', '1', '1'), ('193', '2', '1', '1535100914', '每天首次登录送积分', '1', '系统', '1', '1'), ('194', '52', '1', '1535100978', '每天首次登录送积分', '1', '系统', '1', '1'), ('195', '52', '0', '1535126401', '订单取消，退还消费积分', '0', 'fengkun', '0', '1'), ('196', '16', '60', '1535126401', '购买商品送积分', '1', '系统', '60', '1'), ('197', '51', '190', '1535212801', '购买商品送积分', '1', '系统', '190', '1'), ('198', '2', '1', '1535283181', '每天首次登录送积分', '1', '系统', '1', '1'), ('199', '26', '1', '1535338916', '每天首次登录送积分', '1', '系统', '1', '1'), ('200', '27', '1', '1535339051', '每天首次登录送积分', '1', '系统', '1', '1'), ('201', '25', '1', '1535339154', '每天首次登录送积分', '1', '系统', '1', '1'), ('202', '16', '1', '1535340642', '每天首次登录送积分', '1', '系统', '1', '1'), ('203', '53', '1', '1535340715', '会员注册送积分', '1', '系统', '1', '1'), ('204', '53', '1', '1535340715', '每天首次登录送积分', '1', '系统', '1', '1'), ('205', '53', '0', '1535341058', '订单取消，退还消费积分', '0', 'chopper', '0', '1'), ('206', '53', '1', '1535341141', '在线支付送积分', '1', '系统', '1', '1'), ('207', '2', '1', '1535353721', '每天首次登录送积分', '1', '系统', '1', '1'), ('208', '2', '1', '1535370972', '文字评论送积分', '1', '系统', '1', '1'), ('209', '27', '1', '1535418382', '每天首次登录送积分', '1', '系统', '1', '1'), ('210', '26', '1', '1535419187', '每天首次登录送积分', '1', '系统', '1', '1'), ('211', '25', '1', '1535419460', '每天首次登录送积分', '1', '系统', '1', '1'), ('212', '47', '1', '1535438520', '每天首次登录送积分', '1', '系统', '1', '1'), ('213', '54', '1', '1535442163', '每天首次登录送积分', '1', '系统', '1', '1'), ('214', '55', '1', '1535443163', '每天首次登录送积分', '1', '系统', '1', '1'), ('215', '2', '1', '1535444112', '每天首次登录送积分', '1', '系统', '1', '1'), ('216', '46', '1', '1535445904', '每天首次登录送积分', '1', '系统', '1', '1'), ('220', '27', '0', '1535462984', '订单取消，退还消费积分', '0', 'appliance', '0', '1'), ('221', '25', '1', '1535504609', '每天首次登录送积分', '1', '系统', '1', '1'), ('222', '27', '1', '1535505893', '每天首次登录送积分', '1', '系统', '1', '1'), ('223', '55', '1', '1535507093', '每天首次登录送积分', '1', '系统', '1', '1'), ('224', '2', '1', '1535509769', '每天首次登录送积分', '1', '系统', '1', '1'), ('225', '2', '1', '1536046991', '每天首次登录送积分', '1', '系统', '1', '1'), ('226', '45', '1', '1536301632', '每天首次登录送积分', '1', '系统', '1', '1'), ('227', '16', '1', '1536303849', '每天首次登录送积分', '1', '系统', '1', '1'), ('228', '45', '1', '1545731873', '每天首次登录送积分', '1', '系统', '1', '1'), ('229', '45', '1', '1545731945', '在线支付送积分', '1', '系统', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `es_member_receipt`
-- ----------------------------
DROP TABLE IF EXISTS `es_member_receipt`;
CREATE TABLE `es_member_receipt` (
  `receipt_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '会员发票id',
  `member_id` int(8) DEFAULT NULL COMMENT '会员id',
  `receipt_type` varchar(50) DEFAULT NULL COMMENT '发票类型',
  `receipt_title` varchar(255) DEFAULT NULL COMMENT '发票抬头',
  `receipt_content` varchar(255) DEFAULT NULL COMMENT '发票内容',
  `tax_no` varchar(255) DEFAULT NULL COMMENT '发票税号',
  `reg_addr` varchar(255) DEFAULT NULL COMMENT '注册地址',
  `reg_tel` varchar(255) DEFAULT NULL COMMENT '注册电话',
  `bank_name` varchar(100) DEFAULT NULL COMMENT '开户银行',
  `bank_account` varchar(255) DEFAULT NULL COMMENT '银行账户',
  `is_default` int(2) NOT NULL COMMENT '是否为默认',
  PRIMARY KEY (`receipt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='会员发票(es_member_receipt)';

-- ----------------------------
--  Records of `es_member_receipt`
-- ----------------------------
BEGIN;
INSERT INTO `es_member_receipt` VALUES ('1', '51', 'VATORDINARY', '易族智汇（北京）科技有限公司', '明细', '91110114674296653Y', null, null, null, null, '0'), ('2', '51', 'VATORDINARY', '易族智汇（南京）科技有限公司', '明细', '91110114674296653N', null, null, null, null, '0'), ('3', '51', 'VATORDINARY', '易族智汇（天津）科技有限公司', '明细', '91110114674296653T', null, null, null, null, '1');
COMMIT;

-- ----------------------------
--  Table structure for `es_notice_log`
-- ----------------------------
DROP TABLE IF EXISTS `es_notice_log`;
CREATE TABLE `es_notice_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `notice_content` varchar(255) DEFAULT NULL COMMENT '站内信内容',
  `send_time` bigint(50) DEFAULT NULL COMMENT '发送时间',
  `is_delete` int(10) DEFAULT NULL COMMENT '是否删除 ：1 删除   0  未删除',
  `is_read` int(10) DEFAULT NULL COMMENT '是否已读 ：1已读   0 未读',
  `type` varchar(10) DEFAULT NULL COMMENT '消息类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8 COMMENT='店铺站内消息(es_notice_log)';

-- ----------------------------
--  Table structure for `es_receipt_history`
-- ----------------------------
DROP TABLE IF EXISTS `es_receipt_history`;
CREATE TABLE `es_receipt_history` (
  `history_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '发票历史id',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `member_id` int(8) DEFAULT NULL COMMENT '会员id',
  `receipt_type` varchar(50) DEFAULT NULL COMMENT '发票类型',
  `receipt_title` varchar(100) DEFAULT NULL COMMENT '发票抬头',
  `receipt_amount` decimal(20,2) DEFAULT NULL COMMENT '发票金额',
  `receipt_content` varchar(255) DEFAULT NULL COMMENT '发票内容',
  `tax_no` varchar(100) DEFAULT NULL COMMENT '税号',
  `reg_addr` varchar(255) DEFAULT NULL COMMENT '注册地址',
  `reg_tel` varchar(50) DEFAULT NULL COMMENT '注册电话',
  `bank_name` varchar(50) DEFAULT NULL COMMENT '开户银行',
  `bank_account` varchar(200) DEFAULT NULL COMMENT '银行账户',
  `add_time` bigint(20) DEFAULT NULL COMMENT '开票时间',
  `member_name` varchar(100) DEFAULT NULL COMMENT '会员名称',
  PRIMARY KEY (`history_id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COMMENT='发票历史(es_receipt_history)';

-- ----------------------------
--  Records of `es_receipt_history`
-- ----------------------------
BEGIN;
INSERT INTO `es_receipt_history` VALUES ('1', '20180821000001', '16', null, null, '67.32', null, null, null, null, null, null, '1534846758', 'food'), ('2', '20180821000002', '50', null, null, '6099.00', null, null, null, null, null, null, '1534847172', '回到过去'), ('3', '20180821000003', '50', null, null, '1596.00', null, null, null, null, null, null, '1534847204', '回到过去'), ('4', '20180821000004', '50', null, null, '2299.00', null, null, null, null, null, null, '1534847217', '回到过去'), ('5', '20180821000005', '50', null, null, '189.00', null, null, null, null, null, null, '1534847228', '回到过去'), ('6', '20180821000006', '50', null, null, '2299.00', null, null, null, null, null, null, '1534847240', '回到过去'), ('7', '20180821000007', '50', null, null, '3697.00', null, null, null, null, null, null, '1534847262', '回到过去'), ('8', '20180821000008', '50', null, null, '1199.00', null, null, null, null, null, null, '1534847278', '回到过去'), ('9', '20180821000009', '50', null, null, '2997.00', null, null, null, null, null, null, '1534847294', '回到过去'), ('10', '20180821000010', '50', null, null, '3182.00', null, null, null, null, null, null, '1534847309', '回到过去'), ('11', '20180821000011', '50', null, null, '6486.00', null, null, null, null, null, null, '1534847327', '回到过去'), ('12', '20180821000012', '50', null, null, '11997.00', null, null, null, null, null, null, '1534847342', '回到过去'), ('13', '20180821000013', '50', null, null, '11999.00', null, null, null, null, null, null, '1534847476', '回到过去'), ('14', '20180821000014', '50', null, null, '15.90', null, null, null, null, null, null, '1534847476', '回到过去'), ('15', '20180821000015', '50', null, null, '22597.95', null, null, null, null, null, null, '1534847476', '回到过去'), ('16', '20180821000016', '50', null, null, '249.00', null, null, null, null, null, null, '1534847476', '回到过去'), ('17', '20180821000017', '27', null, null, '1049.00', null, null, null, null, null, null, '1534847724', 'appliance'), ('18', '20180821000018', '27', null, null, '2999.00', null, null, null, null, null, null, '1534847740', 'appliance'), ('19', '20180821000019', '27', null, null, '3699.00', null, null, null, null, null, null, '1534847748', 'appliance'), ('20', '20180821000020', '27', null, null, '1299.00', null, null, null, null, null, null, '1534847756', 'appliance'), ('21', '20180821000021', '27', null, null, '2599.00', null, null, null, null, null, null, '1534847789', 'appliance'), ('22', '20180821000022', '27', null, null, '4198.00', null, null, null, null, null, null, '1534847803', 'appliance'), ('23', '20180821000023', '27', null, null, '399.00', null, null, null, null, null, null, '1534847828', 'appliance'), ('24', '20180821000024', '27', null, null, '6798.00', null, null, null, null, null, null, '1534847855', 'appliance'), ('25', '20180821000025', '27', null, null, '399.00', null, null, null, null, null, null, '1534847855', 'appliance'), ('26', '20180821000026', '27', null, null, '10198.00', null, null, null, null, null, null, '1534847874', 'appliance'), ('27', '20180821000027', '27', null, null, '1738.00', null, null, null, null, null, null, '1534847889', 'appliance'), ('28', '20180821000028', '27', null, null, '3699.00', null, null, null, null, null, null, '1534847900', 'appliance'), ('29', '20180821000029', '27', null, null, '120.00', null, null, null, null, null, null, '1534847921', 'appliance'), ('30', '20180821000030', '27', null, null, '1778.00', null, null, null, null, null, null, '1534847947', 'appliance'), ('31', '20180821000031', '27', null, null, '4799.00', null, null, null, null, null, null, '1534847947', 'appliance'), ('32', '20180821000032', '27', null, null, '249.00', null, null, null, null, null, null, '1534847964', 'appliance'), ('33', '20180821000033', '27', null, null, '19337.00', null, null, null, null, null, null, '1534847978', 'appliance'), ('34', '20180821000034', '27', null, null, '1778.00', null, null, null, null, null, null, '1534848113', 'appliance'), ('35', '20180821000035', '27', null, null, '62861.00', null, null, null, null, null, null, '1534848113', 'appliance'), ('36', '20180821000036', '27', null, null, '4556.90', null, null, null, null, null, null, '1534848113', 'appliance'), ('37', '20180821000037', '27', null, null, '385.00', null, null, null, null, null, null, '1534848757', 'appliance'), ('38', '20180821000038', '27', null, null, '25.99', null, null, null, null, null, null, '1534848783', 'appliance'), ('39', '20180821000039', '27', null, null, '58.90', null, null, null, null, null, null, '1534848794', 'appliance'), ('40', '20180821000040', '27', null, null, '198.00', null, null, null, null, null, null, '1534848801', 'appliance'), ('41', '20180821000041', '27', null, null, '135.00', null, null, null, null, null, null, '1534848808', 'appliance'), ('42', '20180821000042', '27', null, null, '59.80', null, null, null, null, null, null, '1534848821', 'appliance'), ('43', '20180821000043', '27', null, null, '996.00', null, null, null, null, null, null, '1534848846', 'appliance'), ('44', '20180821000044', '27', null, null, '239.90', null, null, null, null, null, null, '1534848960', 'appliance'), ('45', '20180821000045', '16', null, null, '199.00', null, null, null, null, null, null, '1534849355', 'food'), ('46', '20180821000046', '16', null, null, '6184.00', null, null, null, null, null, null, '1534849419', 'food'), ('47', '20180821000047', '16', null, null, '159.90', null, null, null, null, null, null, '1534849447', 'food'), ('48', '20180821000048', '16', null, null, '18447.00', null, null, null, null, null, null, '1534849489', 'food'), ('49', '20180821000049', '46', null, null, '4788.00', null, null, null, null, null, null, '1534849722', 'blue'), ('50', '20180821000050', '46', null, null, '15640.00', null, null, null, null, null, null, '1534849732', 'blue'), ('51', '20180821000051', '46', null, null, '16495.00', null, null, null, null, null, null, '1534849741', 'blue'), ('52', '20180821000052', '46', null, null, '3897.00', null, null, null, null, null, null, '1534849750', 'blue'), ('53', '20180821000053', '46', null, null, '429.00', null, null, null, null, null, null, '1534849757', 'blue'), ('54', '20180821000054', '46', null, null, '4022.00', null, null, null, null, null, null, '1534849789', 'blue'), ('55', '20180821000055', '27', null, null, '519.80', null, null, null, null, null, null, '1534854174', 'appliance'), ('56', '20180821000056', '27', null, null, '6446.00', null, null, null, null, null, null, '1534854428', 'appliance'), ('57', '20180821000057', '27', null, null, '6446.00', null, null, null, null, null, null, '1534854444', 'appliance'), ('58', '20180821000058', '27', null, null, '24631.00', null, null, null, null, null, null, '1534854600', 'appliance'), ('59', '20180821000059', '27', null, null, '6184.00', null, null, null, null, null, null, '1534854790', 'appliance'), ('60', '20180821000060', '16', null, null, '25.99', null, null, null, null, null, null, '1534855396', 'food'), ('61', '20180821000061', '16', null, null, '25.99', null, null, null, null, null, null, '1534855489', 'food'), ('62', '20180821000062', '16', null, null, '77.97', null, null, null, null, null, null, '1534855641', 'food'), ('63', '20180821000063', '16', null, null, '11999.00', null, null, null, null, null, null, '1534855784', 'food'), ('64', '20180821000064', '16', null, null, '31.80', null, null, null, null, null, null, '1534855837', 'food'), ('65', '20180821000130', '27', null, null, '642.90', null, null, null, null, null, null, '1534860136', 'appliance'), ('66', '20180822000001', '51', null, null, '25.90', null, null, null, null, null, null, '1534930946', 'm_18555555555'), ('67', '20180823000001', '51', 'VATORDINARY', '易族智汇（南京）科技有限公司', '999.00', '明细', '91110114674296653N', null, null, null, null, '1535004810', 'm_18555555555'), ('68', '20180823000002', '51', 'VATORDINARY', '易族智汇（南京）科技有限公司', '999.00', '明细', '91110114674296653N', null, null, null, null, '1535005346', 'm_18555555555'), ('69', '20180823000003', '16', null, null, '60.00', null, null, null, null, null, null, '1535005785', 'food'), ('70', '20180823000115', '51', 'VATORDINARY', '易族智汇（南京）科技有限公司', '190.40', '明细', '91110114674296653N', null, null, null, null, '1535033977', 'm_18555555555'), ('71', '20180823000116', '51', 'VATORDINARY', '易族智汇（南京）科技有限公司', '369.00', '明细', '91110114674296653N', null, null, null, null, '1535033977', 'm_18555555555'), ('72', '20180823000117', '51', 'VATORDINARY', '易族智汇（南京）科技有限公司', '318.00', '明细', '91110114674296653N', null, null, null, null, '1535033977', 'm_18555555555'), ('73', '20180824000233', '52', null, null, '1288.00', null, null, null, null, null, null, '1535102922', 'fengkun'), ('74', '20180827000001', '53', 'VATORDINARY', '1333', '380.00', '明细', '91110114674296653Y', null, null, null, null, '1535341023', 'chopper'), ('75', '20180827000002', '53', 'VATORDINARY', '1333', '380.00', '明细', '91110114674296653Y', null, null, null, null, '1535341105', 'chopper'), ('76', '20180828000066', '27', null, null, '11999.00', null, null, null, null, null, null, '1535462928', 'appliance'), ('77', '20180829000001', '55', null, null, '35.60', null, null, null, null, null, null, '1535507189', 'shoptnt7');
COMMIT;

-- ----------------------------
--  Table structure for `es_ship_template`
-- ----------------------------
DROP TABLE IF EXISTS `es_ship_template`;
CREATE TABLE `es_ship_template` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) DEFAULT NULL COMMENT '模板名称',
  `type` smallint(1) DEFAULT NULL COMMENT '1 重量算运费 2 计件算运费',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='运费模版(es_ship_template)';

-- ----------------------------
--  Table structure for `es_ship_template_child`
-- ----------------------------
DROP TABLE IF EXISTS `es_ship_template_child`;
CREATE TABLE `es_ship_template_child` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `template_id` int(10) DEFAULT NULL COMMENT '外键  模板id',
  `first_company` int(10) DEFAULT NULL COMMENT '首个（件）',
  `first_price` decimal(20,2) DEFAULT NULL COMMENT '首个（件）价格',
  `continued_company` int(10) DEFAULT NULL COMMENT '续个（件）',
  `continued_price` decimal(20,2) DEFAULT NULL COMMENT '续个（件）价格',
  `area` longtext COMMENT '地区json',
  `area_id` longtext COMMENT '地区id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='运费模板子模板(es_ship_template_child)';

SET FOREIGN_KEY_CHECKS = 1;
